Matching one position to another

[Steviefiege]

Hi,

At the top of my page i have this:

Highest Rated Player (Available):

Beestin, Alfie

Attacking Midfielder

500

<colgroup><col width="220"><col width="152"><col width="157"><col width="118"></colgroup><tbody>
</tbody>

At the side i have this: Goalkeeper Full Back (Right) Central Defender Defensive Centre Back Full Back (Left) Advanced Playmaker Advanced Playmaker Inside Forward (Right) Attacking Midfielder Inside Forward (Left) Advanced Forward <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col width="220"><col width="152"><col width="157"><col width="118"></colgroup><tbody>
</tbody>

What MATCH formula do i need to use to get him to go at the side of his correct position? (In bold)

Rgs
Steve

 

[Scott T]

	A	B	C	D
1	Highest Rated Player (Available):	Beestin, Alfie	Attacking Midfielder	500
2
3
4	Goalkeeper
5	Full Back (Right)
6	Central Defender
7	Defensive Centre Back
8	Full Back (Left)
9	Advanced Playmaker
10	Advanced Playmaker
11	Inside Forward (Right)
12	Attacking Midfielder	Beestin, Alfie
13	Inside Forward (Left)
14	Advanced Forward

<COLGROUP><COL style="BACKGROUND-COLOR: rgb(218,231,245)"><COL><COL><COL><COL></COLGROUP><TBODY>
</TBODY>

Sheet2​

Worksheet Formulas Cell Formula B4 =IF(A4=$C$1,$B$1,"") <TBODY> </TBODY>

<TBODY>
</TBODY>

and copy down

Note the positions must match exactly in spacing and letters so you can not just have full back in C1 you would need full back (right) or full back (left)

 

[Steviefiege]

Thank you, didn't think it was as easy as that

 

[Steviefiege]

How would i do this?.....
Here is a list of my players, positions & rating: (It's not them all, just a few) & below that is my teamsheet

Boyle, Andy	Central Defender	64.71
Butler, Andy	Central Defender	62.06
Boyle, Andy	Defensive Centre Back	62
Butler, Andy	Defensive Centre Back	61.2
Andrew, Danny	Full Back (Left)	61
Lawlor, Ian	Goalkeeper	60
Rowe, Tommy	Full Back (Left)	59.5
Coppinger, James	Attacking Midfielder	59
Blair, Matty	Full Back (Right)	58.5
Rowe, Tommy	Inside Forward (Left)	58.1
Alcock, Craig	Full Back (Right)	58
Marquis, John	Advanced Forward	57.38
Coppinger, James	Advanced Playmaker	57

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Goalkeeper
Full Back (Right)
Central Defender	Boyle, Andy
Defensive Centre Back
Full Back (Left)
Advanced Playmaker
Advanced Playmaker
Inside Forward (Right)
Attacking Midfielder
Inside Forward (Left)
Advanced Forward

<colgroup><col><col></colgroup><tbody>
</tbody>

What i'm wanting is for example, Andy Boyle who's in the team at Central Defender is now used & the position also. I want all the players in the top list who have either been selected (Andy Boyle) or position selected (Central Defender) to not be able to be picked again for any other position. Does that make sense?

Steve