Bring cell data from another sheet

[hakale]

This is quite hard to explain so please bear with me.

asd.PNG

Let's imagine these two rectangles are different sheets. I want to compare the the left data (T1, T2, T3...) to the right data (S4, F3, T1...), and if the left data is found in the right data list, it returns the value RIGHT to the found data. So for example, I want to see if T1 is found on the right list, it should scroll through all the data on the right list and when it finds the T1, it returns the cell value to the right of it on the yellow cell which in this case would be "T-One". Is it possible to do this?

[benishiryo]

welcome to the forum, hakale. it sounds like VLOOKUP can do the job for you. assuming 2nd rectangle in Sheet2 column A:B. and 1st rectangle "T1" inside cell B2, try this in C2:
=VLOOKUP(B2,Sheet2!A:B,2,0)

i developed a tool to help people learn VLOOKUP. try downloading this file here:
https://www.excelforum.com/tips-and-...-how-tool.html

[hakale]

Thank you, benishiryo, works like a charm!