Spreadsheet: 37007d1234949516-functions-similar-to-vlookup-holiday4ever
Sheet: WEEK 1

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 | 80 | 168 | 175 | 423
 | Total HCAP: |  |  | 29 | 29 | 29 | 87 |  |  | Total HCAP: |  |  | 47 | 47 | 47 | 141
 | Gross Total: |  |  | 152 | 223 | 202 | 577 |  |  | Gross Total: |  |  | 127 | 215 | 222 | 564
 | Won (W, L or D): |  |  | W | W | L | W |  |  | Won (W, L or D): |  |  | L | L | W | L
 | Points Won: |  |  | 2 | 3 | 1 | 1 | 7 |  | Points Won: |  |  | 0 | 1 | 3 | 0 | 4
 |  |  |  | 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
League Standings after Week 1
 |  | Match | Total | Total | Total | High | High | High | High
 |  | Points | Points | Pinfall | Pinfall | Scratch | Scratch | Handicap | Handicap
Position | Team Standings | Won | Won | Scratch | W/HCP | Game | Series | Game | Series | Bowler No
1 | [NAME] | 10 | 10 | 576 | 645 | 212 | 576 | 235 | 645 | 4
2 | G Green | 10 | 10 | 318 | 603 | 113 | 318 | 208 | 603 | 7 |  |  | My Comment…
3 | A [NAME] | 7 | 7 | 490 | 577 | 194 | 490 | 223 | 577 | 1 |  |  | I want them to show like this but not done in manually, could you help me how to put all datas in each cell automatically similar to vlookup or something like that.
4 | E Ellen | 7 | 7 | 475 | 574 | 177 | 475 | 210 | 574 | 5
5 | B Black | 4 | 4 | 423 | 564 | 175 | 423 | 222 | 564 | 2
6 | [NAME] | 2 | 2 | 475 | 535 | 190 | 475 | 210 | 535 | 6
7 | C Coles | 0 | 0 | 325 | 493 | 117 | 325 | 173 | 493 | 3
8 | H Harris |  |  |  |  |  |  |  |  | 8
 | 1ST OVERALL |  | 2ND OVERALL |  | 3RD OVERALL |  | 1ST THIS WEEK |  | 2ND THIS WEEK
MALE
Game | 212 | D Davies | 194 | A [NAME] | 175 | B Black | 212 | D Davies | 194 | A [NAME]
W/HCP | 235 | D Davies | 223 | A [NAME] | 222 | B Black | 235 | D Davies | 223 | A [NAME] |  |  | My Comment…
Series | 576 | D Davies | 490 | A [NAME] | 423 | B Black | 576 | D Davies | 490 | A [NAME] |  |  | Wondering could I change each column between B and K in equal length for each column in this section only?
W/HCP | 645 | D Davies | 577 | A [NAME] | 564 | B Black | 645 | D Davies | 577 | A [NAME]
FEMALE |  |  |  |  |  |  |  |  |  |  |  |  | Also could you help me how to enter these data automatically? Similar to vlookup?
Game | 190 | [NAME] | 177 | E Ellen | 113 | G Green | 190 | [NAME] | 177 | E Ellen
W/HCP | 210 | E Ellen | 210 | [NAME] | 208 | G Green | 210 | E Ellen | 210 | [NAME]
Series | 475 | E Ellen | 475 | [NAME] | 318 | G Green | 475 | E Ellen | 475 | [NAME]
W/HCP | 603 | G Green | 574 | E Ellen | 535 | [NAME] | 603 | G Green | 574 | E Ellen
BOWLER NO | INDIVIDUAL RECORDS | GME | PINS | AVE | HCP | HSG | HSS | HHG | HHS
1 | A [NAME] | 3 | 490 | 163 | 29 | 194 | 490 | 223 | 577
2 | B Black | 3 | 423 | 141 | 47 | 175 | 423 | 222 | 564 |  |  | My Comment…
3 | C Coles | 3 | 325 | 108 | 73 | 117 | 325 | 173 | 493 |  |  | I want them to show like this but not done in manually, could you help me how to put all datas in each cell automatically, again similar to vlookup?
4 | [NAME] | 3 | 576 | 192 | 6 | 212 | 576 | 235 | 645
5 | E Ellen | 3 | 475 | 158 | 33 | 177 | 475 | 210 | 574
6 | [NAME] | 3 | 475 | 158 | 33 | 190 | 475 | 210 | 535
7 | G Green | 3 | 318 | 106 | 75 | 113 | 318 | 208 | 603
8 | H Harris |  |  | 110 | 72