| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning 0 instead of #N/A when no value is found
When using:
=VLOOKUP(A5,'010425'!$A$5:$F$3368,5,FALSE) and an exact match is not found, Excel is returning a 0 instead of the #N/A. This is causing me fits because 0 is a valid value and I therefore cannot sort out the 'not founds'. I have verified that the cells are in fact empty, and do not contain zeros. Why would excel be returning a 0 instead of #N/A? Any help would be greatly appreciated. Thanks, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning an alternative value if lookup cannot be found in array | Excel Discussion (Misc queries) | |||
| Not Found Function | Excel Discussion (Misc queries) | |||
| VLookup Value not found ? | Excel Discussion (Misc queries) | |||
| vlookup not found | Excel Worksheet Functions | |||
| IF NOT FOUND | Excel Worksheet Functions | |||
Threaded Mode
