Doing a vlookup on data copied from another file(pivot table). the function
returns N/A on certain fields. It seems like the formats of these fields
cannot be equalized.

For example 989 (from a pivot table) does not match with 989 in another
range. If I re-type over the 989, it will work. I tried formatting both rows
to make sure they were the same - still did not work. Anyone experience this?
Thanks for your help