Brillant! So, simple, so beautiful!

I REALLY do appreciate EVERYONE who contributes on this site. It has been a
GREAT learning experience for me.

Thank-you EVERYONE.

"bpeltzer" wrote:

Alternately, if you continue to get imported data of this form, you could
embed the conversion from text to number in the lookup formula. Instead of
=vlookup(a1...), =vlookup(value(a1)...)

"Dave Peterson" wrote:

Your key column in the lookup table is numeric, but the value that you're
matching up is Text.

You can coerce those Text values to number values by:
selecting an empty cell
edit|copy
select the range of text numbers
edit|Paste special|check add



DTTODGG wrote:

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.

--

Dave Peterson