Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |