Returning a value in one cell based on the criteria of another cel

K

Kirstin

I'm sure this is possible, just not able to figure it out right now. Here is
a basic spreadsheet w/ names in one column, and numbers in the next.
A B C
Name Average
Mark 875
Paul 823
Tim 146
Gary 166

Highest: 875

The user would like to not only return the highest average on that last
line, but also the name. For example we want it to read Mark 875 in that
last line. Getting the 875 is easy using the =max, having it then return the
name next to it is not as easy. Is this possible?
 
D

Dave

Hi,
If your table is A2:B5 and your MAX formula is in B9, try this in A9
=INDEX(A2:A5,MATCH(B9,B2:B5,0))

Regards - Dave.
 

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

Add a row and totals based on changing cell values 2
Finding specific text in one cell and returning data from another 8
Multiple cells to look up and return values to another spreadsheet 1
Cell and Sheet Reference/Return 3
Criteria of One query based on a field in another query 2
Finding values of one list in another 2
Want to find max in a range then return a name from a cell 1
Using a lookup to return multiple values in one cell?? 1

Top