Hello-

I'm attempting a VLOOKUP.

The lookup value is a field that has the little green triangle in the upper
left corner of the cell (like when you put an apostrophe before a number) ie
10054

The col_index_nbr in another file is a number 10054 (without the little
green triangle).

When I attempt a VLOOKUP - it does not work.
If I re-type the col_index_nbr so that is begins with an apostrophe, the
lookup works. But my file is huge and I can't re-type all of these numbers.
If I reformat them to "text", it still does not find a match.

Please help.