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:

State 16/08/2017 13/09/2017 20/09/2017 27/09/2017 04/10/2017 11/10/2017 18/10/2017 20/10/2017 1 0 0 0 0 11 19 112 0 2 0 0 0 20 0 0 68 0 3 0 0 0 0 71 7 39 0 <tbody> </tbody>

<tbody>
</tbody>

For my results,

State	Result
2 (dynamically changing)	18/10/2017

<tbody>
</tbody>

 

[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))