Post the exact formula you're using. Also, describe how the lookup
table is organized--i.e., is it sorted by the lookup criteria, and, if
so, how is it sorted?

Dave
Steve wrote:
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