Typo alert...

Make sure that the look up range includes enough columns:

=VLOOKUP("0345N9",A1:B25,2,FALSE)
(A1:a25 changed to A1:B25)

Mike H wrote:

Marina,

Ignore the apostrophe and do your lookup as if it wasn't there and it will
work

=VLOOKUP("0345N9",A1:a25,2,FALSE)

Mike

"Marina Tuttle" wrote:

I got a bunch of numbers that look like this 0345N9 and I want to have the
apostrophe Not the quote in front: '0345N9. I have done the regular stuff
of going to data, text to columns, apostrophy as text qualifier and then
click the botton "text."

The cell will show the green triangle as usual on the upper left corner but
the apostrophe is not there to be seen. Then when I want to do a vlookup it
will not find it because it misses the apostrophe.

I tried also to concatenate the cell to an apostrophe, it will not work.

Is there another way?

--

Dave Peterson