In answer to your other questions in Post#20, you can use VLOOKUP only when the item you are looking up is on the left of the items you want to return, whereas with INDEX/MATCH you can look up on any column and return data from either the left or the right of it.

You can do what you propose for the grades for doubles and Trios, but you also need to remember Mixed teams. Just follow the layout that I used for the singles grades tables, and the formula that I used can be amended to suit the range where the tables are - I would think that you would have those formulae on the Doubles and Trios sheets.

Well, I hope you can progress with this in my absence - I leave in a couple of hours.

Pete