VLOOKUP Problem

[andyp161]

Hi,

When using VLOOKUP, if a Lookup value is found but the column specifie
is empty, VLOOKUP returns a 0. I am currently using IFISERROR in orde
to prevent error returns where lookup values are not found, but i
there something that I can add to the formula so that 0s are no
returned when the lookup value is found but the specified column i
empty?

Kind regards

And

 

[Debra Dalgleish]

You can use the IF function with the VLOOKUP formula. There's an example
here:

http://www.contextures.com/xlFunctions02.html#IF

 

[Frank Kabel]

Hi
try a formula such as the following:
=IF(ISNA(VLOOKUP(...)),"",IF(VLOOKUP(...)=0,"",VLOOKUP(...)))

Note: If you have many of these formlas this may slow down your file