Lookup for text and return text from the same row

[TK2013]

Seemed simple, thought I could find a solution googling. But couldn't so here I am asking for your help.

Attached sample document.

Need to lookup for text in Column B and return it's matching row's Column A text.

For eg: in Col. C I need the formula.
Looking for XYZ in Col. B and return ABC from Col. A

[CARACALLA]

C2=IFERROR(INDEX($A$2:$A$100,MATCH(B2,$B$2:$B$100,0)),"")

Copy down

[TK2013]

I moved the column B to Column A and used VLOOKUP and it works. I guess for now, I am good.

[Crooza]

use index match combination like this

Please Login or Register  to view this content.

[TK2013]

C2=IFERROR(INDEX($A$2:$A$100,MATCH(B2,$B$2:$B$100,0)),"")

Copy down

Wow! Thank you. It works. Now I don't have to move the column.

[TK2013]

use index match combination like this

Please Login or Register  to view this content.

Thank you.