Finding a text value

[saneri]

Hi guys,

This could be a simple solution for you experts, but I would be most happy if you could help me :) 

I need Excel to find the maximum value (in this case 6000) and return the text string in row 1 (i this case Lemons). See the attached file below.

Any help would be much appreciated!

Best regards

Eric

[#2]

@saneri 

=INDEX(1:1,AGGREGATE(14,6,COLUMN(B2:G6)/(B2:G6=MAX(B2:G6)),1))

[#3]

@Detlef Lewin thanks! I tried inserting the formula i my work sheet, but Excel won't accept it, Could you possibly attach the .xlsx file with your formula?

[#4]

@saneri 

See attached file.