Vlookup return 0 when cell is blank
 

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

Vlookup return 0 when cell is blank
 

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



Paul wrote:

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

Vlookup return 0 when cell is blank
 

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.

"Paul" wrote:

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