How about

=VLOOKUP(MAX(A1:A1000),A1:B1000,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"shwekhaw" wrote in message
oups.com...
Hi I am not professional excel user. But I am wondering if anyone can
help me write short formula for the following.
I use MAX(A10:A1000) to get the maximum value in Column A. But I want
return value to be whatever value on the same row under column B.

Thank you.