The data is likely not a match, regardless of what you think you are seeing.
Easy test is to find the entry you are looking up (Assume cell B2) and then
find where you think the matching cell is (Assume H99), and then in any
other cell put =B2=H99 and see if you get TRUE or FALSE as a result. If it
doesn't match, then use =ISNUMBER or =ISTEXT on each to see if they really
are what you thought they were.

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

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




"Mike" wrote in message
...
For simplicity, I have the following vlookup formula listed below, where
the
first number would be in cell A3 and the range I'm trying to find the
number
is in cell A5:B5, and the result is in C5. However, I keep getting an
#N/A
for my response. I have formatted the entire worksheet and all numbers as
a
number and not text. This only happens to several rows in my hugh
spreadheet.
The other formulas work. Any idea why this is happening to these several
cells?

63311

63311 40813 #N/A =VLOOKUP(A3,$A$5:$B$5,2,FALSE)


Thanks,
Mike