Search one column and return value from next column

[shwekhaw]

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.

 

[Nick Hodge]

How about

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Aladin Akyurek]

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.