Using MAX to reference a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the maximum value in a row or column with text and numbers 2
How do I reference the cell which returned a lookup value? 1
Max function for row with named cells 3
Column header for Max value? Index/array function? 5
Find max value in a row and return column title 5
Max (A1:A1), relating to other cells 2
Conditional MAX 5
Nested IF & MAX Function 4

Back
Top