lookup

[bongobus]

looking for some help and hopefully solution please folks

2 sheets

1st sheet data entry

2nd sheet display


1st sheet in column A some cells blank some contain a dropdown selection

selections are example OP or TA or OC up to about 10 selections

column b will have a name against this selection same row example

sheet 1

	A	B	C
1
2
3	TA	peter
4
5	OC	smith

<tbody>
</tbody>

I want 2nd sheet to look for an TA in sheet 1 grab the name and return this to a fixed area on sheet 2

again look for in sheet 1 a OP grab the name against this and return this to another fixed area sheet 2

	a	b
1	IC
2	OP
3	OA	Smith
4	TA	PETER

<tbody>
</tbody>

 

[Joe4]

I don't understand why Smith is being applied to code "OA" on sheet 2 when it is associated with "OC" on sheet 1.
Can you explain the logic here?

 

[bongobus]

I don't understand why Smith is being applied to code "OA" on sheet 2 when it is associated with "OC" on sheet 1.
Can you explain the logic here?

Lol spelling mistake

 

[Joe4]

If you are just trying to lookup the value for the second column from the first sheet, take a look at using a VLOOKUP formula, i.e.
https://www.techonthenet.com/excel/formulas/vlookup.php