Can you post some example data and the formula you are using? What is the
cell location of what it is returning versus what it should be returning.
Is your table in ascending order? Try sorting it again to see if the lookup
value stays in the original spot.


--

wrote in message
...
Gang,

I have had this issue previously and it cropping up again. I am have
vlookup formula that is set to find an exact match. I know the match
is in my table. However, it is not finding it. This is a formula
repeated row after row an 95% of the formulas are pulling the expected
info. I can't figure out why a couple of cells/formulas are having
this problem.

I have tried the obvious:

Copying and pasting the actual verbatium formula lookup value and
pasting in the lookup table - I thought maybe I had an extra space or
character in my formula.

Used another value and it worked.

Tried formatting changes...

anyway, this has happened before and I am sure I am overlooking
something obvious. Any thoughts?

Thanks

PAZ