Well, R would be a column instead of a row, so you want to find the max in
column R, and retrieve the label in column A corresponding to the max value,
right?

=INDEX($A$1:$A$40,MATCH(MAX($R$1:$R$40),$R$1:$R$40 ,0))


"Jshendel" wrote:

Hello.
I would like to find a maximum value across a row of 24 and return the title
I have given that column.
So, if the max value of row R is in cell R20, I would like the function to
return the name in cell A20.
Thanks,
Josh