Simple VLOOKUP formula doesn't seem to work

[inddon]

Hello there,

I have a simple VLOOKUP function, and it just doesn't seem to work. Wondering why?

Could you please advise? Attach the sample workbook.

Thanks & regards,
Don

 

[Hui]

Don

The values in Column G are Text not Numbers

Select Column G
Goto the Data, Text to Columns Tab
Delimitered,
Next
Finish

I would also change H2: =IFERROR(VLOOKUP($G2,tt,2),"Not found")
Then copy down

You could also use: =IFERROR(VLOOKUP(VALUE($G2),tt,2),"Not found")
if you can't change Column G

 

[inddon]

Don

The values in Column G are Text not Numbers

Select Column G
Goto the Data, Text to Columns Tab
Delimitered,
Next
Finish

I would also change H2: =IFERROR(VLOOKUP($G2,tt,2),"Not found")
Then copy down

You could also use: =IFERROR(VLOOKUP(VALUE($G2),tt,2),"Not found")
if you can't change Column G

Phew!!
Thanks a lot Hui.

Regards,
Don

 

[Im_Offset]

Don

The values in Column G are Text not Numbers

Select Column G
Goto the Data, Text to Columns Tab
Delimitered,
Next
Finish

I would also change H2: =IFERROR(VLOOKUP($G2,tt,2),"Not found")
Then copy down

You could also use: =IFERROR(VLOOKUP(VALUE($G2),tt,2),"Not found")
if you can't change Column G

Did not know about the value function...cool!