Returning 0 instead of #N/A when no value is found
=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
That's not possible. If the formula returns 0 it's finding an exact match
but if column 5 contains an empty cell then the result will be 0.
If you want the #N/A when column 5 is empty:
=IF(VLOOKUP(A5,'010425'!$A$5:$F$3368,5,0)="",#N/A,VLOOKUP(A5,'010425'!$A$5:$F$3368,5,0))
--
Biff
Microsoft Excel MVP
"RobertSD" wrote in message
...
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
|