display the value of a cell adjacent to the cell with max value

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

Guest

I have a very large spreadsheet that is constantly being added to. I have a
function that displays the max value of a particular column, but I also want
to display the name that coincides with it. Since the name is located in a
different column but same row number, is there a way to display it? (e.g.
A2="Mark", B2=97.8)
Any help would be greatly appreciated.
 
Hi!

Here's one way:

=INDEX(A2:A11,MATCH(MAX(B2:B11),B2:B11,0))

Note: if there is more than one instance of max the formula will return the
corresponding value of the first instance.

Biff
 
You must log in or register to reply here.

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

displaying adjacent cell when using max/min formulae 7
Display contents of adjacent cells 3
Get highest value and adjacent cell value 12
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Cell value with multiple values to vlookup 7
Finding location (or start cell) of highest consecutive values 3
Select multiple adjacent cells of multiple cells without selecting 7
Changing entire row based on 1 MAX cell value (Conditional Formatt 2

Back
Top