replace maximum value of each row into column header value

For each ID, I need its maximum value and corresponding buffer distance.
It has 15000 IDs (column A) with each showing calculated ratio per buffered distance (row 1).
How can I make another column showing just max value's corresponding buffer distance (row 1), so each ID can contain two values - maximum ratio and corresponding distance?

Welcome to the forum.

Pleae attach the workbook, not a picture of it - instructions at the top of the page. Make sure you show expected results (manually entered).

Try this:

=INDEX($B$1:$AO$1,MATCH(MAX($B2:$AO2),$B2:$AO2,0))

Drag copy down.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.