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

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?

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

One way:

=INDEX(A2:A5,MATCH(MAX(B2:B5),B2:B5,FALSE))

In article ,
Kirstin wrote:

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?

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

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.