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


"MikeyB" wrote in message
...
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" wrote:

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

=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


"MikeyB" wrote in message
...
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