VLOOKUP value refering to an Empty Cell

JJ · May 7, 2010

I have a vlookup formula in a cell refering to an empty cell giving me #N/A
but what do I have to do to get a 0 value.?

Tx

Ronx · May 7, 2010

Suggest you ask in a forum or newsgroup that deals with spreadsheets - FrontPage (used for building web sites) does not have a vlookup function.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp/wf-menu.aspx

JJ presented the following explanation :

VLOOKUP value refering to an Empty Cell

JJ

Ronx