Print the column header for the highest value in a row

[guillm]

Hello,
I was wondering if it was possible to do this with Excel. I have tried various combinations of formulas from my limited knowledge, but I am stuck now.

Below is an example. My data (numbers) is in columns that have a header ("text X"). In column D, I would like to print for each row the header value of the maximum value in the corresponding row.

Please Login or Register  to view this content.

Using the example above, in row 2, the maximum value is 50 and it corresponds to "text A"; in row 4 the maximum value is 100 and it corresponds to "text B".

Many thanks for your help and your time!
All the best,

G

[popipipo]

Please Login or Register  to view this content.

Try it with this.

[guillm]

It worked! Thanks a lot. I need to learn a bit more about INDEX/MATCH it seems.