INDEX MATCH (or not?) to return column header based on the highest value in the row

[TheGent]

I have two worksheets, the first contains a list of items, the second a data set.

I am wanting to create a formula in sheet one, which looks up to the data set, finds the highest value in that row and then returns the column header (a date) from this data set.

I have included what would be the correct entries to return on worksheet one in red.

Can this be done?

Worksheet 1
Section	Result
Eggs	04/10/2017
Bread	20/09/2017
Milk	27/09/2017
Worksheet 2
Section	16/08/2017	13/09/2017	20/09/2017	27/09/2017	04/10/2017	11/10/2017	18/10/2017	20/10/2017
Eggs	0	0	0	0	11	19	112	0
Bread	0	0	0	20	0	0	68	0
Milk	0	0	0	0	71	7	39	0

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>

 

[TheGent]

Worksheet one should be as below, some reasons dates changed when I formatted.

Worksheet 1
Section	Result
Eggs	18/10/2017
Bread	18/10/2017
Milk	04/10/2017

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Jonmo1]

Try this in Worksheet 1, B2 and filled down

=INDEX(Sheet2!$B$1:$I$1,MATCH(MAX(Sheet2!B2:I2),Sheet2!B2:I2,0))

 

[TheGent]

Try this in Worksheet 1, B2 and filled down

=INDEX(Sheet2!$B$1:$I$1,MATCH(MAX(Sheet2!B2:I2),Sheet2!B2:I2,0))

Like a dream