Choosing a column based on this maximum value of one cell in said column

[YourExcellence]

Hello Excel Forum!

I have a matrix, where i would like to extract the column which has the highest value of a specific unit (here E). I have attached my Excel Sheet where the problem is illustrated. I hope you will be able to help me!

Cheers,

YourExcellence

autofix.xlsx

[NeedForExcel]

See if this is what you want

=INDEX(E11:H11,MATCH(MAX(E16:H16),E16:H16,0))

[hotbird]

Hi YourExcellence,

you could use the following formula : =INDEX(E12:H12;MATCH(MAX($E$16:$H$16);$E$16:$H$16;0)) based on your example

autofix.xlsx


sorry i didn't see there was the same answer already submitted when i sent my one

[YourExcellence]

Thanks guys, this is exactly what I was looking for!

[NeedForExcel]

Glad it helped