Vlookup return 0 when cell is blank

[Guest]

Hi,

Would anybody know why a Vlookup formula would return 0 (i.e. Zero) when the
contents of the cell that is referenced by the cell is blank.

E.g the formula is:

=IF($E$12 = "","",VLOOKUP(G22,[Data.xls]DECAP_ALL2!F:X,19,FALSE))

I know the formula is working fine as it reurns the correct result (either
blank or and alpha numeric from from referenced cell) but for some reason
some results are return 0 when I would expect blank

Any help appreciated

Paul

 

[Dave Peterson]

=if($e$12="","",if(vlookup(...)="","",vlookup()))

Hi,

Would anybody know why a Vlookup formula would return 0 (i.e. Zero) when the
contents of the cell that is referenced by the cell is blank.

E.g the formula is:

=IF($E$12 = "","",VLOOKUP(G22,[Data.xls]DECAP_ALL2!F:X,19,FALSE))

I know the formula is working fine as it reurns the correct result (either
blank or and alpha numeric from from referenced cell) but for some reason
some results are return 0 when I would expect blank

Any help appreciated

Paul

 

[Guest]

Actually, the reason that sometimes it is returning blank is that it is not
blank. If you look at those cells, most likely you will find that a single
space has been entered (some people erroneously believe that entering a
single space is the same as deleting the contents of the cell.) If the cell
is truly blank, you will see a zero when using vlookup.