Help pls! Max func return val of diff cell?

[impakt]

Hi all,

I am trying to use the max function to find the highest value in a row, but display the value of another row (same column).

Eg: Find the highest value in the row A10:H10 but display the value of row A5:H5 that matches the column the the highest value was found in.

In other words...If D10 has the highest value (total rainfall for April), and D5 is the label for the column (April) , I want to dsplay the name of the month (D5) as the result, not the value of D10.

Can this be done? Or is there a better way?


Thanks

Paul.

[olasa]

Try this:
=INDEX(A5:H5,1,MATCH(MAX(A10:H10),A10:H10))

Ola Sandstrom


Note:
The formula can only handle One max value.