Matching 2 Cells to get the 3rd

[Steviefiege]

Hi, i'm hoping this is an easy one, i just can't get my head around the formula to use.
Below is my spreadsheet with all my players on the left & every position they play in & their ratings.
On the right is every individual player & their BEST rating. What i'm wanting is for on the right under BEST POSITION is to match the player & the rating to get their BEST POSITION.
For example: Aaron Taylor-Sinclair his best rating is 59.29%, under BEST POSITION i want it to say CWB (Left) as thats his best position but i cant get the formula right. I've put it in bold on the left as so you can see which one i mean.

PLAYER	POSITION	RATING				PLAYER		RATING	BEST POSITION
Frazer Richardson	CWB (Right)					Aaron Taylor-Sinclair		59.29%
Gary Taylor-Fletcher	AVP	66.67%				Andrew Williams
Paul Keegan	AVP	65.00%				Andy Butler
Gary Taylor-Fletcher	DLP	63.89%				Benjamin Greasley
Mathieu Baudry	BPD	62.35%				Cedric Evina
Paul Keegan	DLP	62.22%				Conner Williamson
Tommy Rowe	CWB (Left)	61.67%				Craig Alcock
Tommy Rowe	AVP	61.11%				Dany N'Guessan
Andy Butler	BPD	60.88%				David Foley
Andrew Williams	Winger (Right)	60.45%				Dean Winnard
Gary Taylor-Fletcher	CF	60.23%				Frazer Richardson
Craig Alcock	BPD	60.00%				Gary McSheffrey
Aaron Taylor-Sinclair	CWB (Left)	59.29%				Gary Taylor-Fletcher
Tommy Rowe	IF (Left)	59.29%				Harry Middleton
Aaron Taylor-Sinclair	BPD	59.12%				Jai Quitongo
Tommy Rowe	DLP	58.33%				Joe Pugh
Gary Taylor-Fletcher	Winger (Right)	58.18%				Joe Wright
Cedric Evina	CWB (Left)	58.10%				John Marquis
Andrew Williams	IF (Left)	56.79%				Jordan Houghton
Jordan Houghton	DLP	56.67%				Jordan Linley
David Foley	Winger (Right)	56.36%				Joseph McCormick

<tbody>
</tbody>

Kind Regards
Steve

 

[jtakw]

As I have a busy day tomorrow and may not have time to respond, and you haven't answered my questions above.

Assuming the setup is like my Post # 8, use C3 and E3 formulas if there are No Blank rows.
Use D3 and F3 formulas if there are Blank rows in between different positions.

Book1
	A	B	C	D	E	F
1	Position		Player	Player	Rating	Rating
2
3	WB (Right)		Matty Blair	Matty Blair	58.5	58.5
4	CD		Andy Butler	Andy Butler	70.83	70.83
5	CD		Andy Boyle	Andy Boyle	68.33	68.33
6	WB (Left)		Danny Andrew	Danny Andrew	61	61
7			#NUM!		#NUM!
8	BBM		Henrik Bjordal	Henrik Bjordal	55.53	55.53
9	BBM		Ben Whiteman	Ben Whiteman	54.21	54.21
10			#NUM!		#NUM!
11	IF (Right)		James Coppinger	James Coppinger	60.71	60.71
12	IF (Left)		Alfie May	Alfie May	50.71	50.71
13			#NUM!		#NUM!
14	F9		Liam Mandeville	Liam Mandeville	56.92	56.92
15	F9		John Marquis	John Marquis	54.23	54.23
Sheet220

Cell Formulas
Range	Formula
C3	{=INDEX(Sheet221!A$1:A$33,MATCH(A3&E3,Sheet221!C$1:C$33&Sheet221!B$1:B$33,0))}
D3	{=IFERROR(INDEX(Sheet221!A$1:A$33,MATCH(A3&E3,Sheet221!C$1:C$33&Sheet221!B$1:B$33,0)),"")}
E3	{=LARGE(IF(Sheet221!C$1:C$33=A3,Sheet221!B$1:B$33),COUNTIF(A$3:A3,A3))}
F3	{=IFERROR(LARGE(IF(Sheet221!C$1:C$33=A3,Sheet221!B$1:B$33),COUNTIF(A$3:A3,A3)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Book1
	A	B	C
1	Alex Kiwomya	49.64	IF (Right)
2	Alfie Beestin	52.14	IF (Right)
3	Alfie May	50.71	IF (Left)
4	Andrew Williams	53.46	F9
5	Andy Boyle	68.33	CD
6	Andy Butler	70.83	CD
7	Anthony Greaves	30	IF (Right)
8	Ben Whiteman	54.21	BBM
9	Branden Horton	46.25	CD
10	Cameron Barnett	36.92	F9
11	Cedric Evina	47	WB (Left)
12	Corie Andrews	50	IF (Right)
13	Craig Alcock	60.42	CD
14	Danny Andrew	61	WB (Left)
15	Henrik Bjordal	55.53	BBM
16	Issam Ben Khemis	48.95	BBM
17	James Coppinger	60.71	IF (Right)
18	Joe Wright	56.25	CD
19	John Marquis	54.23	F9
20	Jordan Houghton	51.58	BBM
21	Liam Mandeville	56.92	F9
22	Luke McCullough	57.92	CD
23	Mathieu Baudry	60	CD
24	Matty Blair	58.5	WB (Right)
25	Mitchell Lund	53.5	WB (Right)
26	Myron Gibbons	32.69	F9
27	Niall Mason	56.5	WB (Right)
28	Rieves Boocock	36.15	F9
29	Rodney Kongolo	57.08	CD
30	Shane Blaney	49.58	CD
31	Tom Anderson	56.25	CD
32	Tommy Rowe	59.5	WB (Left)
33	Tyler Garrett	54	WB (Left)
Sheet221