Get data from a header in Excel.

JesusOcio 

You can achieve this in Excel by using a combination of functions like MAX, MATCH, and INDEX to find the maximum value in the range Y5:AA5 and then return the corresponding header from the range Y1:AA1. Here is how you can do it step by step:

1. In a cell where you want to display the result (let's say it's in cell D1), enter the following formula:

=INDEX(Y1:AA1, MATCH(MAX(Y5:AA5), Y5:AA5, 0))

Here is what this formula does:

• MAX(Y5:AA5) finds the maximum value in the range Y5:AA5.
• MATCH(MAX(Y5:AA5), Y5:AA5, 0) finds the position (column number) of the maximum value within the range Y5:AA5. The 0 as the last argument of MATCH ensures an exact match.
• INDEX(Y1:AA1, ...) returns the corresponding header from the range Y1:AA1 based on the column number obtained from the MATCH function.

So, when you enter this formula in cell D1, it will display "A Auditivo" if Y5 is the highest, "B Visual" if Z5 is the highest, and "C Kinestésico" if AA5 is the highest.

Make sure to adjust the cell references (Y5:AA5, Y1:AA1, and cell D1) to match your actual worksheet layout.

Alternative formula: =CHOOSE(MATCH(MAX(Y5:AA5), Y5:AA5, 0), "A Auditivo", "B Visual", "C Kinestésico")

This formula achieves the same result as the previous one but in a more compact way.

The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.