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.