Vlookup a value with multiple results

[CGV]

Hi All,

I am struggling to find a formula for an excel exercise I have tried with Match and Index but not much of a luck ( maybe the formula was not set up properly).

E.g.

I have a list with name and seats , this list has multiple name against same seat. as per below:

Seat Name
1 A
2 B
3 C
4 D
5 E
6 F
1 G
3 H

I would like to allocate the giving seat against the right name as per below :


Seat Name Should be
1 ? A
2 ? B
3 ? C
1 ? G
4 ? D
3 ? H
5 ? E
6 ? F

Can you please help me?

Thanks

Carmine