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