Displaying contents of adjacent cells.

[Guest]

I have a list of scores on a rewards scheme sheet. adjacent to these scores
are the names of the record holders. IF scores are in B1:B16 the names are in
A1:A16. I've used the max feature to find the max score and display in cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

 

[Damon Longworth]

This will work, but it will get the name of the first matching Max score:

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[Gary Brown]

Try this:-

=INDEX(A1:A16,MATCH(G12,B1:B16,0))

One problem, if you have more than one person with the same score, i
will only display the first one in the list, if this won't happen, i
shouldn't be a proble

 

[Guest]

Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges
C/D5:C/D16. presume it would be easy to change cell numbers.

 

[Damon Longworth]

Try:

=INDEX(A5:A16,MATCH(B28,B5:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[Guest]

tried this one, but its still not returning the correct name. seems to
generate the last on the list, which isnt the highest value.

 

[Damon Longworth]

Is there a match? Try adding the False argument:

=INDEX(A5:A16,MATCH(B28,B5:B16,0))




--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[Guest]

Thanks mate, there was no match. but it seems the 0 helped, why is this?