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