On May 14, 1:50 pm, CLEM wrote:
While attempting to use VLOOKUP THE LOOKUP VALUE IS 12345 the column that
has the list of values to be looked at has '12345 so it is not recognized
and I get NA. The table I am working with has the ' attached to all of the
entries in that column. Is there any way I can get rid of the hash mark so
that my lookup will recognize the vale?

One way is to use TEXT(A1,"@") as the lookup_value in the VLOOKUP
function instead of A1 when the lookup_value is in A1.

BTW it's an apostrophe ('), not a hash.

Ken Johnson