HELP! Add a name to cell based on range of highest value.

[azz_90]

Hi,
So i'm creating a scorecard for tenpin bowling and after entering all the scores, i'm trying to find the name which relates to the bowler (participant) in C4:C18 to be entered in R4 , R5 and so on. So currently, the high score at the moment in S4 is 221. i want to find the formula used to find that bowler name in the range of C4:c18 (or in other words, in-line with the score. or the bowler who achieved the score of 221 in F6 would have the person's name from C6 appear in R4.

 

[tygrrboi]

Does this do it?

=Index($C$4:$C$18, Match($S4, $F$4:$F$18, 0))

 

[azz_90]

Yes ! Thankyou !!