Find an example in your data where you think they are the same but give an
#N/A in the formula, and then in any other cell, just do =Cell1=Cell2 using
your two values. If it says FALSE then no matter what you are seeing, they
are NOT the same.

If the data is text then look at leading/trailing spaces as a root cause,
and if it is numeric then look at decimal precision.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Steve" wrote in message
...
I'm using vlookup in Excel 2003 to return exact matches from another sheet
and it has some error where it returns the #N/A error for a few values,
even
though the matching target is present. I don't think it's user error -- I
can
open the same file in Open Office Calc and all the values are correctly
returned. Is there any fix for this? I have all the current patches
applied.
--
Steve