look up max

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CTURNER82 - 27 May 2008 19:37 GMT

Hi. This seems like it should be simple but I'm not having any luck. If
column A is a list of names and B is a list of corresponding numbers (like
test scores), in C1 I want to find the highest score in B and show the name
of the person to whom it belongs. I can find the MAX in column B, but can't
seem to get beyond that.
Any help would be appreciated.

Reply to this Message

Don Guillett - 27 May 2008 19:43 GMT

try this where col i has the numbers and col h has the names
=INDEX(H:H,MATCH(MAX(I:I),I:I))

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi. This seems like it should be simple but I'm not having any luck. If
> column A is a list of names and B is a list of corresponding numbers (like
[quoted text clipped - 4 lines]
> seem to get beyond that.
> Any help would be appreciated.

Reply to this Message

Niek Otten - 27 May 2008 19:47 GMT

=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0))

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi. This seems like it should be simple but I'm not having any luck. If
| column A is a list of names and B is a list of corresponding numbers (like
| test scores), in C1 I want to find the highest score in B and show the name
| of the person to whom it belongs. I can find the MAX in column B, but can't
| seem to get beyond that.
| Any help would be appreciated.

Reply to this Message