Returning 0 instead of #N/A when no value is found
If A5 is empty, then try toggling this setting:
(in xl2003 menus)
Tools|Options|Transition tab|Uncheck Transition Formula Evaluation
(I'd uncheck all those transition settings)
If you're using xl2007, I think it's buried under:
Office Button|Excel Options
Then I have no idea!
RobertSD wrote:
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
--
Dave Peterson
|