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.