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

Many thanks Pecoflyer.

I doubt if I would have been able to figure this out. I was working with Index and Match and going nowhere quickly.

In my actual spreadsheet, I do have the names in the first column, and I wish I had placed that portion in my test sheet as I can now see why it would have been easier to pull the data.

Thank you for all your help.

David