How to link MAX value to certain category?

[olivierv]

I'm coping with what is probably very easy to solve, but I just can't find the solution. Played around with MAX and VLOOKUPs, but that doesn't seem to work.

For example: cell A2 should highlight the main subsector, if a company has most of its sales in "Financial Data Services", then use "Financial Data Services" as the main subsector.

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F
1	Max Letter	W	E	R	T	Y
2	E	0	100	0	0	0
3	Y	0	25	0	0	75
4	W	75	0	15	10	0
5	W	100	0	0	0	0
6	Y	0	0	0	0	100
7	R	0	0	100	0	0
8	E	0	75	0	0	25
9	Y	25	0	10	10	55
10	R	0	0	100	0	0
Sheet4

Cell Formulas
Range	Formula
A2	=INDEX($B$1:$F$1,MATCH(MAX($B2:$F2),$B2:$F2,0))

 

[olivierv]

Fantastic, thanks!