Using MAX to reference a row
 

I am trying to retrieve data associated with my maximum in one column. How
can I use the MAX function on column A to return the value in column B in the
same row?

For example, if "=MAX(A1:A1000)" returns 25.67 from cell A315, how do can I
get a value from B315 returned? The row in which the maximum is found from
column A is variable and this needs to be repeated many times, so a function
is highly desireable.
Thanks!!

Using MAX to reference a row
 

=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))

Adjust B1:B5 and A1:A5 to your situation

--
Kind regards,

Niek Otten


"monty" wrote in message
...
I am trying to retrieve data associated with my maximum in one column. How
can I use the MAX function on column A to return the value in column B in
the
same row?

For example, if "=MAX(A1:A1000)" returns 25.67 from cell A315, how do can
I
get a value from B315 returned? The row in which the maximum is found
from
column A is variable and this needs to be repeated many times, so a
function
is highly desireable.
Thanks!!