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?