Index/Match and return header

[eaje92]

Hi i would like some help with returning column headers based on the highest value in the specific row that will change constantly. Much appreciated!

An example would be:

[TABLE="class: cms_table, width: 820"]
<tbody>[TR]
[TD][TABLE="class: cms_table, width: 820"]
<tbody>[TR]
[TD]State[/TD]
[TD="align: right"]16/08/2017[/TD]
[TD="align: right"]13/09/2017[/TD]
[TD="align: right"]20/09/2017[/TD]
[TD="align: right"]27/09/2017[/TD]
[TD="align: right"]04/10/2017[/TD]
[TD="align: right"]11/10/2017[/TD]
[TD="align: right"]18/10/2017[/TD]
[TD="align: right"]20/10/2017[/TD]
[/TR]
[TR]
[TD]1 [/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 0 [/TD]
[TD] 11[/TD]
[TD] 19[/TD]
[TD] 112[/TD]
[TD] 0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 20[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 68[/TD]
[TD] 0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[TD] 71[/TD]
[TD] 7[/TD]
[TD] 39[/TD]
[TD] 0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]


For my results,

[TABLE="class: cms_table, width: 820"]
<tbody>[TR]
[/TR]
[TR]
[TD]State[/TD]
[TD]Result[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2 (dynamically changing)[/TD]
[TD]18/10/2017







[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1	State	16/08/2017	13/09/2017	20/09/2017	27/09/2017	4/10/2017	11/10/2017	18/10/2017	20/10/2017		2	18/10/2017
2	1	0	0	0	0	11	19	112	0
3	2	0	0	0	20	0	0	68	0
4	3	0	0	0	0	71	7	39	0
Sheet26

Cell Formulas
Range	Formula
L1	=INDEX(B1:I1,MATCH(MAX(INDEX(B2:I4,MATCH(K1,A2:A4,0),)),INDEX(B2:I4,MATCH(K1,A2:A4,0),),0))