Hey stranger, hope all's well with you [ and couldn't have said it better
myself :-) ]

Best Wishes
ken....................


"Peo Sjoblom" wrote in message
...
You are wrong, read help. When VLOOKUP looks for an exact match there is
no need
to sort anything. Since the OP used FALSE in his formula the reason he
gets an error is simply a mismatch. Leading/trailing spaces, hidden html
characters or numbers formatted as text.



--
Regards,

Peo Sjoblom




"Michael" wrote in message
...
If you read the first paragraph of the Arguments window (while inserting
the
function using the insert formula option), it clearly states that by
default
the table must be sorted in ascending order.
On the range lookup argument, the false is used to return an exact match.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Ken Wright" wrote:

1.- The lookup table must be sorted by the left most column; therefore
I
would try sorting

Not if as per the Ops and your own example, the optional argument of
FALSE
or 0 is included at the end of the formula.

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

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




"Michael" wrote in message
...
Two things come to mind:
1.- The lookup table must be sorted by the left most column; therefore
I
would try sorting
2.- If there is a blank space after 63311 or before it, the lookup
will
fail, what I usually do is:
=Vlookup(Trim(A3),$A$5:$B$5,2,FALSE)

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Mike" wrote:

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