Spreadsheet: 113469d1309362638-joining-2-vlookup-formulas-to-get-a-single-result-test-league
Sheet: Sheet1

 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME 1 |  | OPP TEAM SCORE |  |  |  |  |  | GAME 1 |  | GAME2 |  | GAME 3 |  | [NAME] |  | GAME5 |  | GAME6 |  | TEAM | OPP
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE |  |  | TEAM | TEAM PTS | OPP POINTS | TEAM PTS | OPP POINTS | TEAM PTS | OPP POINTS | TEAM PTS | OPP POINTS | TEAM PTS | OPP POINTS | TEAM PTS | OPP POINTS | TOTAL | TOTAL
 | 8 | 0 | 17 | 1 |  |  | 1 |  | 11 |  |  | 1 |  | 11 |  |  |  | 1
 | 9 | 3 | 16 | 2 |  |  | 2 |  | 12 |  |  | 2 |  | 12 |  |  |  | 2
 | 3 | 4 | 1 | 5 |  |  | 3 |  | 13 |  |  | 3 |  | 13 |  |  |  | 3
 | 5 | 7 | 20 | 6 |  |  | 4 |  | 14 |  |  | 4 |  | 14 |  |  |  | 4
 | 7 | 8 | 18 | 9 |  |  | 5 |  | 15 |  |  | 5 |  | 15 |  |  |  | 5
 | 6 | 1 | 19 | 0 |  |  | 6 |  | 16 |  |  | 6 |  | 16 |  |  |  | 6
 | 10 | 2 | 15 | 3 |  |  | 7 |  | 17 |  |  | 7 |  | 17 |  | THEN SHOW HERE |  | 7
 | 12 | 5 | 13 | 4 |  |  | 8 |  | 18 |  |  | 8 |  | 18 |  |  |  | 8
 | 4 | 6 | 2 | 7 |  |  | 9 |  | 19 |  |  | 9 |  | 19 |  |  |  | 9
 | 11 | 9 | 14 | 8 |  |  | 10 |  | 20 |  |  | 10 |  | 20 |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | ENTERING TEAM SCORE FOR EACH GAME |  |  |  |  |  | MAKE TEAM SCORE SHOW HERE FOR EACH TEAM |  |  |  |  | MAKE OPP TEAM SCORE SHOW HERE FOR EACH TEAM |  |  |  |  |  | 15
 | NOW THIS ISN'T ALWAYS WHERE THE TEAMS |  |  |  |  |  |  | EXAMPLE |  |  |  |  | EXAMPLE |  |  |  |  | 16
 | PLACEMENT LOCATION WILL BE AT ALL TIMES. |  |  |  |  |  |  | TEAM 1 SCORED 5 PTS |  |  |  |  | TEAM 1 SCORED 5 PTS |  |  |  |  | 17
 | SINCE THEY WILL BE PLAYING OTHER ROUNDS |  |  |  |  |  |  | TEAM 3 SCORED 4 PTS |  |  |  |  | TEAM 3 SCORED 4 PTS |  |  |  |  | 18
 | SO, IN THE NEXT SECTION, THEY WILL HAVE TO |  |  |  |  |  |  | MAKE 5 SHOW IN THE COLUMN NEXT TO 1 |  |  |  |  | MAKE 4 SHOW IN THE COLUMN NEXT TO 1 |  |  |  |  | 19
 | LOOKUP WHICH LINE HAS THE TEAM, THEN THE PTS |  |  |  |  |  |  | AND 4 IN COLUMN NEXT TO 3 |  |  |  |  | AND 5 IN COLUMN NEXT TO 3 |  |  |  |  | 20
 | TO ADD TO THE NEXT SECTION
 | EXAMPLE BELOW
 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME2 |  | OPP TEAM SCORE
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE
 | 14 | 4 | 19 | 6 |  |  | 1 |  | 11 |  |  | 1 |  | 11
 | 13 | 4 | 20 | 7 |  |  | 2 |  | 12 |  |  | 2 |  | 12
 | 7 | 7 | 1 | 3 |  |  | 3 |  | 13 |  |  | 3 |  | 13
 | 8 | 7 | 6 | 8 |  |  | 4 |  | 14 |  |  | 4 |  | 14
 | 16 | 4 | 17 | 5 |  |  | 5 |  | 15 |  |  | 5 |  | 15
 | 10 | 4 | 4 | 9 |  |  | 6 |  | 16 |  |  | 6 |  | 16
 | 12 | 3 | 2 | 5 |  |  | 7 |  | 17 |  |  | 7 |  | 17
 | 9 | 5 | 5 | 0 |  |  | 8 |  | 18 |  |  | 8 |  | 18
 | 11 | 2 | 3 | 5 |  |  | 9 |  | 19 |  |  | 9 |  | 19
 | 15 | 8 | 18 | 6 |  |  | 10 |  | 20 |  |  | 10 |  | 20
 | YOU CAN LEAVE ROUNDS 3 & ROUNDS 4 BLANK, SINCE THEY HAVEN'T BEEN PLAYED YET. BUT WHEN I DO A SUM TO GET TOTALS FOR EACH COLUMN, I WOULD GET A #[NAME]! [NAME].
 | ALL TOGETHER THERE WILL BE A TOTAL OF 57 GAMES TO BE PLAYED FOR ALL TEAMS. AND WHEN I TRY TO =SUM(T4,V4,X4,Z4 etc) I WOULD GET AN #[NAME]! ERROR
 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME 3 |  | OPP TEAM SCORE
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE
 | 14 | 1 | 19 | 2 |  |  | 1 |  | 11 |  |  | 1 |  | 11
 | 13 | 4 | 20 | 3 |  |  | 2 |  | 12 |  |  | 2 |  | 12
 | 7 | 5 | 1 | 6 |  |  | 3 |  | 13 |  |  | 3 |  | 13
 | 8 | 8 | 6 | 7 |  |  | 4 |  | 14 |  |  | 4 |  | 14
 | 16 | 9 | 17 | 0 |  |  | 5 |  | 15 |  |  | 5 |  | 15
 | 10 | 2 | 4 | 1 |  |  | 6 |  | 16 |  |  | 6 |  | 16
 | 12 | 3 | 2 | 4 |  |  | 7 |  | 17 |  |  | 7 |  | 17
 | 9 | 6 | 5 | 5 |  |  | 8 |  | 18 |  |  | 8 |  | 18
 | 11 | 7 | 3 | 8 |  |  | 9 |  | 19 |  |  | 9 |  | 19
 | 15 | 0 | 18 | 9 |  |  | 10 |  | 20 |  |  | 10 |  | 20
 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME 4 |  | OPP TEAM SCORE
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE
 | 14 | 2 | 19 | 3 |  |  | 1 |  | 11 |  |  | 1 |  | 11
 | 13 | 5 | 20 | 4 |  |  | 2 |  | 12 |  |  | 2 |  | 12
 | 7 | 6 | 1 | 7 |  |  | 3 |  | 13 |  |  | 3 |  | 13
 | 8 | 9 | 6 | 8 |  |  | 4 |  | 14 |  |  | 4 |  | 14
 | 16 | 0 | 17 | 1 |  |  | 5 |  | 15 |  |  | 5 |  | 15
 | 10 | 3 | 4 | 2 |  |  | 6 |  | 16 |  |  | 6 |  | 16
 | 12 | 4 | 2 | 5 |  |  | 7 |  | 17 |  |  | 7 |  | 17
 | 9 | 7 | 5 | 6 |  |  | 8 |  | 18 |  |  | 8 |  | 18
 | 11 | 8 | 3 | 9 |  |  | 9 |  | 19 |  |  | 9 |  | 19
 | 15 | 1 | 18 | 0 |  |  | 10 |  | 20 |  |  | 10 |  | 20
 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME 5 |  | OPP TEAM SCORE
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE
 | 14 | 3 | 19 | 4 |  |  | 1 |  | 11 |  |  | 1 |  | 11
 | 13 | 6 | 20 | 5 |  |  | 2 |  | 12 |  |  | 2 |  | 12
 | 7 | 7 | 1 | 8 |  |  | 3 |  | 13 |  |  | 3 |  | 13
 | 8 | 0 | 6 | 9 |  |  | 4 |  | 14 |  |  | 4 |  | 14
 | 16 | 1 | 17 | 2 |  |  | 5 |  | 15 |  |  | 5 |  | 15
 | 10 | 4 | 4 | 3 |  |  | 6 |  | 16 |  |  | 6 |  | 16
 | 12 | 5 | 2 | 6 |  |  | 7 |  | 17 |  |  | 7 |  | 17
 | 9 | 8 | 5 | 7 |  |  | 8 |  | 18 |  |  | 8 |  | 18
 | 11 | 9 | 3 | 0 |  |  | 9 |  | 19 |  |  | 9 |  | 19
 | 15 | 2 | 18 | 1 |  |  | 10 |  | 20 |  |  | 10 |  | 20
 |  |  |  |  |  |  |  | TEAM SCORE |  |  | GAME 6 |  | OPP TEAM SCORE
 | TEAM | PTS | TEAM | PTS |  |  | TEAM | SCORE | TEAM | SCORE |  | TEAM | SCORE | TEAM | SCORE
 | 14 | 4 | 19 | 5 |  |  | 1 |  | 11 |  |  | 1 |  | 11
 | 13 | 7 | 20 | 6 |  |  | 2 |  | 12 |  |  | 2 |  | 12
 | 7 | 8 | 1 | 9 |  |  | 3 |  | 13 |  |  | 3 |  | 13
 | 8 | 1 | 6 | 0 |  |  | 4 |  | 14 |  |  | 4 |  | 14
 | 16 | 2 | 17 | 3 |  |  | 5 |  | 15 |  |  | 5 |  | 15
 | 10 | 5 | 4 | 4 |  |  | 6 |  | 16 |  |  | 6 |  | 16
 | 12 | 6 | 2 | 7 |  |  | 7 |  | 17 |  |  | 7 |  | 17
 | 9 | 9 | 5 | 8 |  |  | 8 |  | 18 |  |  | 8 |  | 18
 | 11 | 0 | 3 | 1 |  |  | 9 |  | 19 |  |  | 9 |  | 19
 | 15 | 3 | 18 | 2 |  |  | 10 |  | 20 |  |  | 10 |  | 20