See attached

I used a helper column (BC19-BC29) to retrieve the row number in your table.
You can place it anywhere you want and eventually hide it.

It's also a little odd to place the players' names behind the data, usually they are in the first column of the table. This would have been easier for the VLOOKUP function, but not mandatory.

Also be aware that formulae BB19-BB29 are array fomulae and should be committed with Ctrl+Shift+Enter

Attached Files

Scoresheet test-1.xlsx (14.8 KB, 12 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post