Using MATCH to match 2 columns

[Steviefiege]

Hi,
I have a table below:

<colgroup><col style="mso-width-source:userset;mso-width-alt:6363;width:131pt" width="174"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody>
[TD="class: xl70, width: 174"]team[/TD]
[TD="class: xl70, width: 82"]Matches Pld[/TD]
[TD="class: xl70, width: 64"] [/TD]
[TD="class: xl72, width: 64"]Home Win[/TD]
[TD="class: xl72, width: 64"]Home Draw[/TD]
[TD="class: xl72, width: 64"]Home Loss[/TD]
[TD="class: xl70, width: 64"] [/TD]
[TD="class: xl70, width: 64"]Best Result[/TD]
[TD="class: xl70, width: 64"]Rating[/TD]

[TD="class: xl65"]Accrington Stanley[/TD]
[TD="class: xl70, align: right"]4[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]0[/TD]
[TD="class: xl75"]75[/TD]
[TD="class: xl75"]25[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl65"]AFC Bournemouth[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]50[/TD]
[TD="class: xl75"]50[/TD]
[TD="class: xl75"]0[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl65"]AFC Fylde[/TD]
[TD="class: xl70, align: right"]5[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]60[/TD]
[TD="class: xl75"]20[/TD]
[TD="class: xl75"]20[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl65"]AFC Wimbledon[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]0[/TD]
[TD="class: xl75"]33[/TD]
[TD="class: xl75"]67[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl65"]Aldershot Town[/TD]
[TD="class: xl70, align: right"]5[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]60[/TD]
[TD="class: xl75"]20[/TD]
[TD="class: xl75"]20[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl65"]Arsenal[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"]50[/TD]
[TD="class: xl75"]0[/TD]
[TD="class: xl75"]50[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

</tbody>

Under Best Result how, for example if i use Accrington Stanley, would i put Home Draw & under Rating put 75

Rgs
Steve

 

[KUYJS]

Your question is not clear... Please elaborate

 

[Steviefiege]

In the Best Result column in my table, next to each team i would like it to say which is the highest result. For example, if i take AFC Fylde, their best result is Home Win with a rating of 60. Thats what i want it to say in the last 2 columns

 

[Fluff]

How about

Excel 2013 32 bit
	A	B	C	D	E	F	G	H	I
1	team	Matches Pld		Home Win	Home Draw	Home Loss		Best Result	Rating
2	Accrington Stanley	4		0	75	25		Home Draw	75
3	AFC Bournemouth	2		50	50	0		Home Win	50
4	AFC Fylde	5		60	20	20		Home Win	60
5	AFC Wimbledon	3		0	33	67		Home Loss	67
6	Aldershot Town	5		60	20	20		Home Win	60
7	Arsenal	2		50	0	50		Home Win	50
Sheet1

Cell Formulas
Range	Formula
H2	=INDEX(D$1:F$1,1,MATCH(MAX(D2:F2),D2:F2,0))
I2	=MAX(D2:F2)

 

[Steviefiege]

Thank you Fluff, that's exactly what I wanted.

 

[Fluff]

Glad to help & thanks for the feedback