Vlookup.

GEM · Jan 19, 2009

If a cell is blank where the vlookup function is searching, the answer it's
returning is "0"

How can I have a blank cell instead of a 0??

Bob Phillips · Jan 19, 2009

=IF(vlookup_formula="","",vlookup_formula)

Mike H · Jan 19, 2009

Hi,

Try this

=IF(VLOOKUP(C1,A1:B20,2,FALSE)="","",VLOOKUP(C1,A1:B20,2,FALSE))

This will still return NA# if the lookup values isn't found.

Mike

GEM · Jan 19, 2009

Thank you!!

Bob Phillips said:
=IF(vlookup_formula="","",vlookup_formula)

--
__________________________________
HTH

Bob