Spreadsheet: 35125d1232638686-functions-similar-to-vlookup-standing-sheet
Sheet: WEEK 2

League Recap Sheet
Week 2
 |  | AVE | HCP | 1st | 2nd | 3rd | Series |  |  |  | AVE | HCP | 1st | 2nd | 3rd | Series
7 | G Green | 106 | 75 | 0 | 0 | 0 | 0 | BS | 3 | C Coles | 108 | 73 | 101 | 98 | 215 | 414
 | Total HCAP: |  |  | 0 | 0 | 0 | 0 |  |  | Total HCAP: |  |  | 73 | 73 | 73 | 219
 | Gross Total: |  |  | 0 | 0 | 0 | 0 |  |  | Gross Total: |  |  | 174 | 171 | 288 | 633
 | Won (W, L or D): |  |  | L | L | L | L |  |  | Won (W, L or D): |  |  | W | D | W | W
 | Points Won: |  |  | 0 | 0 | 0 | 0 | 0 |  | Points Won: |  |  | 2 | 1 | 3 | 1 | 7
 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 1 | 0
2 | B Black | 141 | 47 | 151 | 140 | 141 | 432 |  | 8 | H Harris | 110 | 72 | 85 | 87 | 191 | 363
 | Total HCAP: |  |  | 47 | 47 | 47 | 141 |  |  | Total HCAP: |  |  | 72 | 72 | 72 | 216
 | Gross Total: |  |  | 198 | 187 | 188 | 573 |  |  | Gross Total: |  |  | 157 | 159 | 263 | 579
 | Won (W, L or D): |  |  | W | W | L | L |  |  | Won (W, L or D): |  |  | L | L | W | W
 | Points Won: |  |  | 3 | 2 | 0 | 0 | 5 |  | Points Won: |  |  | 0 | 0 | 3 | 1 | 4
 |  |  |  | 1 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 1 | 0
5 | E Ellen | 158 | 33 | 158 | 157 | 159 | 474 |  | 1 | A [NAME] | 163 | 29 | 171 | 166 | 160 | 497
 | Total HCAP: |  |  | 33 | 33 | 33 | 99 |  |  | Total HCAP: |  |  | 29 | 29 | 29 | 87
 | Gross Total: |  |  | 191 | 190 | 192 | 573 |  |  | Gross Total: |  |  | 200 | 195 | 189 | 584
 | Won (W, L or D): |  |  | L | L | W | L |  |  | Won (W, L or D): |  |  | W | W | L | W
 | Points Won: |  |  | 0 | 0 | 3 | 0 | 3 |  | Points Won: |  |  | 3 | 3 | 0 | 1 | 7
 |  |  |  | 0 | 0 | 1 | 0 |  |  |  |  |  | 1 | 1 | 0 | 0
4 | [NAME] | 192 | 6 | 188 | 171 | 199 | 558 |  | 6 | [NAME] | 158 | 33 | 156 | 159 | 162 | 477
 | Total HCAP: |  |  | 6 | 6 | 6 | 18 |  |  | Total HCAP: |  |  | 33 | 33 | 33 | 99
 | Gross Total: |  |  | 194 | 177 | 205 | 576 |  |  | Gross Total: |  |  | 189 | 192 | 195 | 576
 | Won (W, L or D): |  |  | W | L | W | D |  |  | Won (W, L or D): |  |  | L | W | L | D
 | Points Won: |  |  | 2 | 0 | 3 | 0.5 | 5.5 |  | Points Won: |  |  | 0 | 3 | 1 | 0.5 | 4.5
 |  |  |  | 0 | 0 | 1 | 0 |  |  |  |  |  | 0 | 1 | 1 | 0
League Standings after Week 2
 |  | 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] | 5.5 | 10 | 1134 | 1221 | 212 | 576 | 235 | 645 | 4
2 | G Green | 0 | 15.5 | 318 | 603 | 113 | 318 | 208 | 603 | 7 |  |  | My Comment…
3 | A [NAME] | 7 | 7 | 987 | 1161 | 194 | 497 | 223 | 584 | 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 | 3 | 10 | 949 | 1147 | 177 | 475 | 210 | 574 | 5
5 | B Black | 5 | 9 | 855 | 1137 | 175 | 432 | 222 | 573 | 2
6 | [NAME] | 4.5 | 6.5 | 952 | 1111 | 190 | 477 | 210 | 576 | 6
7 | C Coles | 7 | 7 | 739 | 1126 | 215 | 414 | 288 | 633 | 3 |  |  | New Comment I need to sort this ladder, followed by total points won then
8 | H Harris | 4 | 4 | 363 | 579 | 191 | 363 | 263 | 579 | 8 |  |  | total pinfall with handicap
 | 1ST OVERALL |  | 2ND OVERALL |  | 3RD OVERALL |  | 1ST THIS WEEK |  | 2ND THIS WEEK
MALE
Game | 215 | C Coles | 212 | D Davies | 194 | A [NAME] | 215 | C Coles | 199 | [NAME]
W/HCP | 288 | C Coles | 235 | D Davies | 223 | A [NAME] | 288 | C Coles | 205 | [NAME] |  |  | My Comment…
Series | 576 | D Davies | 490 | A [NAME] | 423 | B Black | 558 | D Davies | 497 | 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 | 633 | C Coles | 584 | A [NAME] | 633 | C Coles | 584 | A [NAME]
FEMALE |  |  |  |  |  |  |  |  |  |  |  |  | Also could you help me how to enter these data automatically? Similar to vlookup?
Game | 191 | H Harris | 190 | [NAME] | 177 | E Ellen | 191 | H Harris | 162 | [NAME]
W/HCP | 263 | H Harris | 210 | E Ellen | 210 | [NAME] | 263 | H Harrus | 195 | [NAME]
Series | 477 | [NAME] | 475 | E Ellen | 318 | G Green | 477 | [NAME] | 474 | E Ellen
W/HCP | 603 | G Green | 579 | H Harris | 576 | [NAME] | 579 | H Harris | 576 | [NAME] |  |  | No need to sort this section
 |  |  |  |  |  |  |  |  |  |  |  |  | Note: Must have different bowlers on each catogory of 1st overall, 2nd overall & 3rd overall
 |  |  |  |  |  |  |  |  |  |  |  |  | same for 1st this week and 2nd this week
BOWLER NO | INDIVIDUAL RECORDS | GME | PINS | AVE | HCP | HSG | HSS | HHG | HHS
1 | A [NAME] | 6 | 987 | 164 | 28 | 194 | 490 | 223 | 577
2 | B Black | 6 | 855 | 142 | 46 | 175 | 432 | 222 | 573 |  |  | My Comment…
3 | C Coles | 6 | 739 | 123 | 61 | 215 | 414 | 288 | 633 |  |  | 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] | 6 | 1134 | 189 | 8 | 212 | 576 | 235 | 645
5 | E Ellen | 6 | 949 | 158 | 33 | 177 | 475 | 210 | 574
6 | [NAME] | 6 | 952 | 158 | 33 | 190 | 477 | 210 | 576
7 | G Green | 3 | 318 | 106 | 75 | 113 | 318 | 208 | 603 |  |  | No need to sort this section
8 | H Harris | 3 | 363 | 121 | 63 | 191 | 363 | 263 | 579