Try this:

=INDEX(A:A,MATCH(MAX(R:R),R:R,0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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