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.

<tbody>
[TD="class: xl63"]PLAYER[/TD]
[TD="class: xl63, width: 100"]POSITION[/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 130"]PLAYER[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"]BEST POSITION[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl65"]Frazer Richardson[/TD]
[TD="class: xl66"]CWB (Right)[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl74"]59.29%[/TD]
[TD="class: xl75"][/TD]

[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]AVP[/TD]
[TD="class: xl64"]66.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andrew Williams[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]65.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andy Butler[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]DLP[/TD]
[TD="class: xl64"]63.89%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Benjamin Greasley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Mathieu Baudry[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]62.35%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Cedric Evina[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]62.22%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Conner Williamson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]61.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Craig Alcock[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]61.11%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dany N'Guessan[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Andy Butler[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.88%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]David Foley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]60.45%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dean Winnard[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]CF[/TD]
[TD="class: xl64"]60.23%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Frazer Richardson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Craig Alcock[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Gary McSheffrey[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"] Aaron Taylor-Sinclair
[/TD]
[TD="class: xl66"] CWB (Left) [/TD]
[TD="class: xl64"] 59.29% [/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]Gary Taylor-Fletcher[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]59.29%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Harry Middleton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl65"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]59.12%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jai Quitongo[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]58.33%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joe Pugh[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]58.18%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Joe Wright[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Cedric Evina[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]58.10%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]John Marquis[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]56.79%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Jordan Houghton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl69"]Jordan Houghton[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]56.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jordan Linley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl67"]David Foley[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]56.36%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joseph McCormick[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

</tbody>

Kind Regards
Steve

 

[jtakw]

Hi,

This is one way, Array Formula to be confirmed by CSE (Control, Shift, Enter):

Book1
	A	B	C	D	E	F	G	H	I	J
1	PLAYER	POSITION	RATING				PLAYER		RATING	BEST POSITION
2
3	Frazer Richardson	CWB (Right)					Aaron Taylor-Sinclair		59.29%	CWB (Left)
4	Gary Taylor-Fletcher	AVP	66.67%				Andrew Williams
5	Paul Keegan	AVP	65.00%				Andy Butler
6	Gary Taylor-Fletcher	DLP	63.89%				Benjamin Greasley
7	Mathieu Baudry	BPD	62.35%				Cedric Evina
8	Paul Keegan	DLP	62.22%				Conner Williamson
9	Tommy Rowe	CWB (Left)	61.67%				Craig Alcock
10	Tommy Rowe	AVP	61.11%				Dany N'Guessan
11	Andy Butler	BPD	60.88%				David Foley
12	Andrew Williams	Winger (Right)	60.45%				Dean Winnard
13	Gary Taylor-Fletcher	CF	60.23%				Frazer Richardson
14	Craig Alcock	BPD	60.00%				Gary McSheffrey
15	Aaron Taylor-Sinclair	CWB (Left)	59.29%				Gary Taylor-Fletcher
16	Tommy Rowe	IF (Left)	59.29%				Harry Middleton
17	Aaron Taylor-Sinclair	BPD	59.12%				Jai Quitongo
18	Tommy Rowe	DLP	58.33%				Joe Pugh
19	Gary Taylor-Fletcher	Winger (Right)	58.18%				Joe Wright
20	Cedric Evina	CWB (Left)	58.10%				John Marquis
21	Andrew Williams	IF (Left)	56.79%				Jordan Houghton
22	Jordan Houghton	DLP	56.67%				Jordan Linley
23	David Foley	Winger (Right)	56.36%				Joseph McCormick
Sheet214

Cell Formulas
Range	Formula
J3	{=INDEX(B3:B23,MATCH(G3&I3,A3:A23&C3:C23,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Steviefiege]

Thank you very much, thats worked a treat.

 

[jtakw]

You're welcome, welcome to the forum.

 

[Steviefiege]

Regarding my spreadsheet above. I can't remember how i did the formula in the right hand column for the rating (59.29%). It's just literally getting the highest number on the left hand column for that particular player. Can anyone help please?

 

[jtakw]

That's also going to require an Array formula:

Book1
	A	B	C	D	E	F	G	H	I	J
1	PLAYER	POSITION	RATING				PLAYER		RATING	BEST POSITION
2
3	Frazer Richardson	CWB (Right)					Aaron Taylor-Sinclair		59.29%	CWB (Left)
4	Gary Taylor-Fletcher	AVP	66.67%				Andrew Williams		60.45%	Winger (Right)
5	Paul Keegan	AVP	65.00%				Andy Butler		60.88%	BPD
6	Gary Taylor-Fletcher	DLP	63.89%				Benjamin Greasley		0.00%	#N/A
7	Mathieu Baudry	BPD	62.35%				Cedric Evina		58.10%	CWB (Left)
8	Paul Keegan	DLP	62.22%				Conner Williamson		0.00%	#N/A
9	Tommy Rowe	CWB (Left)	61.67%				Craig Alcock		60.00%	BPD
10	Tommy Rowe	AVP	61.11%				Dany N'Guessan		0.00%	#N/A
11	Andy Butler	BPD	60.88%				David Foley		56.36%	Winger (Right)
12	Andrew Williams	Winger (Right)	60.45%				Dean Winnard		0.00%	#N/A
13	Gary Taylor-Fletcher	CF	60.23%				Frazer Richardson		0.00%	#N/A
14	Craig Alcock	BPD	60.00%				Gary McSheffrey		0.00%	#N/A
15	Aaron Taylor-Sinclair	CWB (Left)	59.29%				Gary Taylor-Fletcher		66.67%	AVP
16	Tommy Rowe	IF (Left)	59.29%				Harry Middleton		0.00%	#N/A
17	Aaron Taylor-Sinclair	BPD	59.12%				Jai Quitongo		0.00%	#N/A
18	Tommy Rowe	DLP	58.33%				Joe Pugh		0.00%	#N/A
19	Gary Taylor-Fletcher	Winger (Right)	58.18%				Joe Wright		0.00%	#N/A
20	Cedric Evina	CWB (Left)	58.10%				John Marquis		0.00%	#N/A
21	Andrew Williams	IF (Left)	56.79%				Jordan Houghton		56.67%	DLP
22	Jordan Houghton	DLP	56.67%				Jordan Linley		0.00%	#N/A
23	David Foley	Winger (Right)	56.36%				Joseph McCormick		0.00%	#N/A
Sheet214

Cell Formulas
Range	Formula
I3	{=MAX(IF(A$3:A$23=G3,C$3:C$23))}
J3	{=INDEX(B$3:B$23,MATCH(G3&I3,A$3:A$23&C$3:C$23,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Steviefiege]

Thank you so much for that, kind of getting there now but still stuck on some more bits. See if i can explain this...
This is my page which automatically picks my squad Sheet 1 (well it will be when its done!)
I've sorted the formula for the rating (58.50). What i want is to match it to the player with that rating in that position which i have got on another sheet, Sheet 2. I'll add it underneath.

Sheet 1
[TABLE="width: 467"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
Position
[/TD]
[TD] [/TD]
[TD]Player
[/TD]
[TD] [/TD]
[TD]Rating
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]WB (Right)
[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD]58.50
[/TD]
[/TR]
[TR]
[TD]CD
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WB (Left)
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]BBM
[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBM
[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]IF (Right)
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IF (Left)
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]F9
[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F9
[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 288"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Sheet 2

Alex Kiwomya
[/TD]
[TD="align: right"]49.64[/TD]
[TD] IF (Right)
[/TD]
[/TR]
[TR]
[TD]Alfie Beestin
[/TD]
[TD="align: right"]52.14[/TD]
[TD] IF (Right)
[/TD]
[/TR]
[TR]
[TD]Alfie May
[/TD]
[TD="align: right"]50.71[/TD]
[TD] IF (Left)
[/TD]
[/TR]
[TR]
[TD]Andrew Williams[/TD]
[TD="align: right"]53.46[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Andy Boyle[/TD]
[TD="align: right"]68.33[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Andy Butler[/TD]
[TD="align: right"]70.83[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Anthony Greaves[/TD]
[TD="align: right"]30.00[/TD]
[TD] IF (Right)
[/TD]
[/TR]
[TR]
[TD]Ben Whiteman[/TD]
[TD="align: right"]54.21[/TD]
[TD] BBM
[/TD]
[/TR]
[TR]
[TD]Branden Horton[/TD]
[TD="align: right"]46.25[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Cameron Barnett[/TD]
[TD="align: right"]36.92[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Cedric Evina[/TD]
[TD="align: right"]47.00
[/TD]
[TD] WB (Left)
[/TD]
[/TR]
[TR]
[TD]Corie Andrews[/TD]
[TD="align: right"]50.00[/TD]
[TD] IF (Right)
[/TD]
[/TR]
[TR]
[TD]Craig Alcock[/TD]
[TD="align: right"]60.42[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Danny Andrew[/TD]
[TD="align: right"]61.00
[/TD]
[TD] WB (Left)
[/TD]
[/TR]
[TR]
[TD]Henrik Bjordal[/TD]
[TD="align: right"]55.53[/TD]
[TD] BBM
[/TD]
[/TR]
[TR]
[TD]Issam Ben Khemis[/TD]
[TD="align: right"]48.95[/TD]
[TD] BBM
[/TD]
[/TR]
[TR]
[TD]James Coppinger[/TD]
[TD="align: right"]60.71[/TD]
[TD] IF (Right)
[/TD]
[/TR]
[TR]
[TD]Joe Wright[/TD]
[TD="align: right"]56.25[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]John Marquis[/TD]
[TD="align: right"]54.23[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Jordan Houghton[/TD]
[TD="align: right"]51.58[/TD]
[TD] BBM
[/TD]
[/TR]
[TR]
[TD]Liam Mandeville[/TD]
[TD="align: right"]56.92[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Luke McCullough[/TD]
[TD="align: right"]57.92[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Mathieu Baudry[/TD]
[TD="align: right"]60.00[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Matty Blair
[/TD]
[TD="align: right"]58.50
[/TD]
[TD] WB (Right)
[/TD]
[/TR]
[TR]
[TD]Mitchell Lund[/TD]
[TD="align: right"]53.50[/TD]
[TD] WB (Right)
[/TD]
[/TR]
[TR]
[TD]Myron Gibbons[/TD]
[TD="align: right"]32.69[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Niall Mason[/TD]
[TD="align: right"]56.50[/TD]
[TD] WB (Right)
[/TD]
[/TR]
[TR]
[TD]Rieves Boocock[/TD]
[TD="align: right"]36.15[/TD]
[TD] F9
[/TD]
[/TR]
[TR]
[TD]Rodney Kongolo[/TD]
[TD="align: right"]57.08[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Shane Blaney[/TD]
[TD="align: right"]49.58[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Tom Anderson[/TD]
[TD="align: right"]56.25[/TD]
[TD] CD
[/TD]
[/TR]
[TR]
[TD]Tommy Rowe[/TD]
[TD="align: right"]59.50
[/TD]
[TD]WB (Left)
[/TD]
[/TR]
[TR]
[TD]Tyler Garrett[/TD]
[TD="align: right"]54.00[/TD]
[TD] WB (Left)
[/TD]
[/TR]
</tbody>[/TABLE]


The player in bold in sheet 2 is the player that wants to be in sheet 1 in the WB (Right) position, i just cant get my head around the formula.

Rgs
Steve


[TABLE="width: 288"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

Book1
	A	B	C	D	E
1	Position		Player		Rating
2
3	WB (Right)		Matty Blair		58.5
4	CD
5	CD
6	WB (Left)
7
8	BBM
9	BBM
10
11	IF (Right)
12	IF (Left)
13
14	F9
15	F9
Sheet220

Cell Formulas
Range	Formula
C3	{=INDEX(Sheet221!A$1:A$33,MATCH(A$3&E$3,Sheet221!C$1:C$33&Sheet221!B$1:B$33,0))}
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

Change cell references/range and sheet name to match your data.

 

[Steviefiege]

Thank you soo soo very much. Another question, Where i have 2 x CD & 2 x BBM & 2 x F9, how do i get the 2nd highest rated player there?

 

[jtakw]

That's going to require a different formula.
So your actual setup is like my Post # 8 above?
Are there actually empty rows (in between different positions) as shown in Post # 8, or not?