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

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

Perhaps the contents of theose problametic cells is not what you think it is.

Try this:
=CODE(A1)
=VALUE(A1)
=ISTEXT(A1)
=ISNUMBER(A1)

For instance, a space in a cell can be e#VALUE!
xamined with =CODE(A1) and the result will be 35. A blank in the same cell
will give a result of #VALUE. Also, sometimes numbers appear as text and
vice versa. Use these:
=ISTEXT(A1)
=ISNUMBER(A1)
to determine what Excel 'sees'.

Try the functions above; these may yield some surprising results!!


Regards,
Ryan--


--
RyGuy


"PCLIVE" wrote:

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