Leauge Stats - Ranking using LOOKUP/SEARCH/INDEX

Hi Pete

I know you are away and not able to reply to this. I just had few days off myself and had a good look last night.

I fully understand how you modified the workbook to a more logical sequence. The team sequences do make sense but I don't understand how it will help me to combine scores in the Doubles and Trios sheet. So I created the Doubles Sheet. I made the team name (or number) and the two players' names into two separate columns. I've renames the "Singles Sheet" to "OverallDATA". I've placed the team names/numbers into the columns you created. I had issues with the Doubles sheet finding the scores for both players and adding them to get a combined set of scores for the TEAM. PLEASE SEE THE ATTACHMENT WITH THE DOUBLES SHEET. In B4 do I use something like

=IFERROR(INDEX(OverallDATA!$A:$A,MATCH($A4,OverallDATA!G:G,0)),"")

. This code fails when you use it in column D. I can't get it to find the second player on team and third (trios). VLOOKUP was used in the other columns to retrieve the data. Is that right? The reports for the doubles sheet is easy enough to change, no problems there.

Some things popped up when playing with it.

1/ Grading a little different when you have doubles. So I put another column for "Team Avg" then used similar approach with grades. As we previously discussed, the formula will not help to identify Seniors, Boys or Girls. We should have a column for Gender (with M/F only), one for Senior,Adult,Child and the grades.
2/ For data entry, when a player does multiple attempts with different players in singles, doubles or trios, Do the name entries (cell) need to be different? Example Player 2, Player 2 (2), Player 2 (3)..? Do the formulas work on duplicate cell entries?
3/ When doing the reports, when you sort Singles data, the doubles report changes and same with trios. Will this not occur if data were separated into Doubles and trios sheets like I'm trying to do?

I will still play with it tonight, hopefully can work it out before you get home