Thread: Finding labeled data in another sheet with the

Hello, first time poster here.

I've recently begun to use excel in order to improve the efficiency of my work, and I've stumbled upon a problem that I can't find a solution for online (probably because it's hard to phrase it).

I have two sheets, sheet 1 is for quantity calculation, and sheet 2 is a legend for certain elements. In this legend I've set up two columns where, for example, A are the elements labeled T1, L1, R1, and B are values (areas), like 300, 500, 700. I'd like to create a function, where when I write T1 in a cell in sheet 1, it then searches sheet 2 for T1 and once found, places the corresponding data value that's in the row next to it in a different cell in sheet 1. I tried with IF functions, but since I'm new to more complex excel functions, I couldn't achieve the flexibility I wanted with it.

Hopefully somebody can enlighten me about this, thanks!

P.S. I couldn't decide on how to name this thread best, so I procrastinated, and obviously forgot to finish it before posting. Sorry about that. :D

One way might be

In B2
=INDEX(Legend!B:B,MATCH(A2,Legend!A:A,0))

Change the values in Sheet1 Column A to see the results

Hope this helps

If you can't be bothered to use a correct title, then I can't be bothered to help.

Thread closed