| 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 |
| 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 | |||
Threaded Mode
