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

#### azz_90

##### New Member
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.

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### tygrrboi

##### Well-known Member
Does this do it?

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

#### azz_90

##### New Member
Yes ! Thankyou !!

Replies
1
Views
274
Replies
6
Views
381
Replies
3
Views
314
Replies
17
Views
2K
Replies
3
Views
551

1,191,173
Messages
5,985,095
Members
439,940
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back