Search one column and return value from next column

S

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.
 
A

Aladin Akyurek

shwekhaw said:
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.
Click to expand...

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.
 
Top