Search one column and return value from next column
 

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.

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.

shwekhaw wrote:
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.


The MAX value is bound more often than not to have multiple instances, a
situation that requires you to retrieve corresponding values from column
B. The link below describes a formula system that can handle such
situations:

http://tinyurl.com/abfok

You need to set the Top N parameter to 1.