Hi,

Excel will return zero if it finds an exact match in colum 1 of the lookup
array and there is a zero or blank cell in column 5 of the lookup array.
Check you data again and I'm sure you'll find there is a match for A5.

Mike

"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