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

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]TA
[/TD]
[TD]peter
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]OC
[/TD]
[TD]smith
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]IC
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]OP
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]OA
[/TD]
[TD]Smith
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]TA
[/TD]
[TD]PETER
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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