Spreadsheet: 37017d1234958028-functions-similar-to-vlookup-holiday4ever
Sheet: Example

League Recap Sheet
Week 1
 |  | AVE | HCP | 1st | 2nd | 3rd | Series |  |  |  | AVE | HCP | 1st | 2nd | 3rd | Series
1 | A [NAME] | 163 | 29 | 123 | 194 | 173 | 490 |  | 2 | B Black | 141 | 47 | 0 | 0 | 0 | 0 | BS
 | Total HCAP: |  |  | 29 | 29 | 29 | 87 |  |  | Total HCAP: |  |  | 0 | 0 | 0 | 0
 | Gross Total: |  |  | 152 | 223 | 202 | 577 |  |  | Gross Total: |  |  | 0 | 0 | 0 | 0
 | Won (W, L or D): |  |  | W | W | L | W |  |  | Won (W, L or D): |  |  | L | L | L | L
 | Points Won: |  |  | 2 | 3 | 1 | 1 | 7 |  | Points Won: |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 1 | 1 | 0 |  |  |  |  |  | 0 | 1 | 1 | 0
3 | C Coles | 129 | 56 | 106 | 102 | 117 | 325 |  | 4 | [NAME] | 171 | 23 | 182 | 182 | 212 | 576
 | Total HCAP: |  |  | 56 | 56 | 56 | 168 |  |  | Total HCAP: |  |  | 23 | 23 | 23 | 69
 | Gross Total: |  |  | 162 | 158 | 173 | 493 |  |  | Gross Total: |  |  | 205 | 205 | 235 | 645
 | Won (W, L or D): |  |  | L | L | L | L |  |  | Won (W, L or D): |  |  | W | W | W | W
 | Points Won: |  |  | 0 | 0 | 0 | 0 | 0 |  | Points Won: |  |  | 3 | 3 | 3 | 1 | 10
 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 1 | 1 | 1 | 0
5 | E Ellen | 158 | 33 | 156 | 177 | 142 | 475 |  | 6 | [NAME] | 174 | 20 | 131 | 190 | 154 | 475
 | Total HCAP: |  |  | 33 | 33 | 33 | 99 |  |  | Total HCAP: |  |  | 20 | 20 | 20 | 60
 | Gross Total: |  |  | 189 | 210 | 175 | 574 |  |  | Gross Total: |  |  | 151 | 210 | 174 | 535
 | Won (W, L or D): |  |  | W | D | W | W |  |  | Won (W, L or D): |  |  | L | D | L | L
 | Points Won: |  |  | 2 | 2 | 2 | 1 | 7 |  | Points Won: |  |  | 0 | 2 | 0 | 0 | 2
 |  |  |  | 0 | 1 | 0 | 0 |  |  |  |  |  | 0 | 1 | 0 | 0
7 | G Green | 81 | 95 | 108 | 97 | 113 | 318 |  | 8 | H Harris | 110 | 72 | 0 | 0 | 0 | 0 | BS
 | Total HCAP: |  |  | 95 | 95 | 95 | 285 |  |  | Total HCAP: |  |  | 0 | 0 | 0 | 0
 | Gross Total: |  |  | 203 | 192 | 208 | 603 |  |  | Gross Total: |  |  | 0 | 0 | 0 | 0
 | Won (W, L or D): |  |  | W | W | W | W |  |  | Won (W, L or D): |  |  | L | L | L | L
 | Points Won: |  |  | 3 | 3 | 3 | 1 | 10 |  | Points Won: |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1 | 1 | 1 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  | Match | Total | Total
 | Team | Points | Pinfall | Pinfall
Position | Standings | Won | Scratch | W/HCP | Bowler No
1 | A [NAME] | 7 | 490 | 577 | 1
2 | B Black | 0 | 0 | 0 | 2
3 | C Coles | 0 | 325 | 493 | 3
4 | [NAME] | 10 | 576 | 645 | 4
5 | E Ellen | 7 | 475 | 574 | 5
6 | [NAME] | 2 | 475 | 535 | 6
7 | G Green | 10 | 318 | 603 | 7
8 | H Harris | 0 | 0 | 0 | 8
League Standings after Week 1
 |  | Match | Total | Total
 | Team | Points | Pinfall | Pinfall
Position | Standings | Won | Scratch | W/HCP | Bowler No
1 | [NAME] | 10 | 576 | 645 | 4 |  | It works now but not for the bowlers who didn't play, see [NAME] and H.Harris above but on the blue section H.Harris appeared twice see pink highlighted.
2 | G Green | 10 | 318 | 603 | 7
3 | A [NAME] | 7 | 490 | 577 | 1
4 | E Ellen | 7 | 475 | 574 | 5 | <<=====
5 | [NAME] | 2 | 475 | 535 | 6
6 | C Coles | 0 | 325 | 493 | 3
7 | H Harris | 0 | 0 | 0 | 8
8 | H Harris | 0 | 0 | 0 | 8
NOTE:    THE RESULTS SHOULD BE THE SAME AS BELOW.
 |  | Match | Total | Total
 | Team | Points | Pinfall | Pinfall
Position | Standings | Won | Scratch | W/HCP | Bowler No
1 | [NAME] | 10 | 576 | 645 | 4
2 | G Green | 10 | 318 | 603 | 7
3 | A [NAME] | 7 | 490 | 577 | 1
4 | E Ellen | 7 | 475 | 574 | 5
5 | [NAME] | 2 | 475 | 535 | 6
6 | C Coles | 0 | 325 | 493 | 3
7 | B Black | 0 | 0 | 0 | 2
8 | H Harris | 0 | 0 | 0 | 8