picking the contents of one cell if another cell meets criteria

[gsloman]

hi folks - i hope someone can help

i've got a list of names and each one has a score - once i've identified the top scorer i want to be able to get their name appearing in another worksheet as top scorer - so if names are in column A and scores are in column G, once the highest score has been identified, i want to be able to take the name of the highest scorer from A and get it to appear in another worksheet - is it possible?

[daddylonglegs]

You can get the first top scorer in the list with a formula like this

=INDEX(A:A,MATCH(MAX(G:G),G:G,0))

but how do you want to proceed if there are joint top scorers, do you need to list all of them?

[gsloman]

Thanks that works - you're a star! but Yes I'd need to list them all if there was atie

[gsloman]

Thanks - could you tell me what does the 0 do at the end of your =INDEX(A3:A23,MATCH(MAX(G3:G23),G3:G23,0)) ? I'm trying to see if anything different at the end might show uip two names when they tie as high scorers