Spreadsheet: 275183d1383372299-vlookup-help-roster-query-
Sheet: Key

 | Input  worksheets required: (week commencing..eg "01-Apr")
 |  | 2013-10-30 00:00:00
 |  |  |  |  | 2301
 |  | Daylight Saving Eff 6 Oct
 |  |  | AMMENDED : 1 Nov 2013 |  |  |  |  |  | Effective  9 Oct 2013 |  |  |  |  |  |  | CS 5/13
 |  |  | 2013-10-02 00:00:00 | 2013-10-09 00:00:00 | 2013-10-16 00:00:00 | 2013-10-23 00:00:00 | 2013-10-30 00:00:00 | 2013-11-06 00:00:00 | 2013-11-13 00:00:00 | 2013-11-20 00:00:00 | 2013-11-27 00:00:00 | 2013-12-04 00:00:00 | 2013-12-11 00:00:00 | 2013-12-18 00:00:00 | 2013-12-25 00:00:00 | 2014-01-01 00:00:00 | 2014-01-08 00:00:00
2 | 812409 | S Barber |  |  |  |  | CP2 | CP1 | CP2 | CP1 | CP2 | CP1 | A | B | C | A | B
3 | 533497 | R Miller |  |  |  |  | CS1 | CS2 | CS1 | CS2 | CS1 | CS2 | CS1 | CS2 | CS1 | CS2
4 | 226967 | D MacQueen |  |  |  |  | CS2 | CS1 | CS2 | CS1 | CS2 | CS1 | CS2 | CS1 | CS2 | CS1
5 | 134948 | R Gillis |  |  |  |  | CP1 | CP2 | CP1 | CP2 | CP1 | L | CP1 | CP2 | CP1 | CP2
6 | 516643 | R Carr |  |  |  |  | A | B | C | A | B | C | L | L | L | L | L
7 | 528648 | M Keast |  |  |  |  | B | C | A | B | C | A | B | C | A | B
8 | 530504 | M Limon |  |  |  |  | C | A | B | C | A | B | C | A | B | C
9 | 741078 | A Dray |  |  |  |  | 1 | 1 | L | L | L | 1 | 1 | 1 | 1 | 1
10 | 826406 | A Hatch |  |  |  |  | F1 | F2 | F3 | F1 | F2 | F3 | F1 | F2 | F3 | F1
11 | 317947 | J [NAME] |  |  |  |  | L | F1 | F2 | F3 | F1 | F2 | F3 | F1 | F2 | F3
12 | 539671 | A.Saunders |  |  |  |  | L | L | L | F2 | F3 | F1 | F2 | F3 | F1 | F2
13 | 206953 | K Phelan |  |  |  |  | P4 | P5 | P6 | L | P1 | P2 | P3 | P4 | P5 | P6
14 | 115862 | C Canhan |  |  |  |  | F2 | F3 | F1 | P4 | P5 | P6 | P7 | P1 | P2 | P3
15 | 104159 | A [NAME] |  |  |  |  | AB | AB | AB | AB | AB | AB | AB | AB | AB | AB | -
16 | 128557 | M Bindoraho |  |  |  |  | F3 | P2 | P3 | P3 | L | L | P6 | P7 | P1 | P2
17 | 771140 | C Smith |  |  |  |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
18 | 885369 | R Price |  |  |  |  | 18 | 18 | 18 | 18 | 18 | 18 | 18 | L | L | L | L
19 | 154218 | L Rosier |  |  |  |  | P5 | P6 | P7 | P1 | P2 | P3 | P4 | L | L | L | L
20 | 142354 | R Murray |  |  |  |  | P6 | P7 | P1 | P2 | P3 | CP2 | CP2 | CP1 | CP2 | CP1 | CP2
21 | 169566 | N Wilson |  |  |  |  | P3 | P4 | P5 | P6 | 1 | P1 | P2 | P3 | P4 | P5
22 | 169565 | S Amadio |  |  |  |  | P2 | P3 | 1 | 1 | L | L | L | L | L | P4
23 | 318474 | P Thomson |  |  |  |  | SL | SL | SL | SL | SL | 20 | L | 20 | 20 | 20
24 | 101770 | J [NAME] |  |  |  |  | - | QC1 | - | - | - | - | - | - | - | - | -
25 |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | -
26 | u | Uncovered |  |  |  |  | P1 | P1 | P4 | P5 | P7 | P4 | P1 | P5 | P6 | P7 | -
27 | u | Uncovered |  |  |  |  | P7 | 20 | P2 | P7 | P4 | P5 | 20 | 18 | 18 | 18 | -
28 | u | Uncovered |  |  |  |  | 20 | - | 20 | 20 | P6 | P7 | P5 | P6 | P7 | P1 | P2
29 | u | Uncovered |  |  |  |  | - | QC2 | - | - | - | - | - | P2 | P3 | - | - | QF Club staff
30 | u | Uncovered |  |  |  |  | - | - | - | - | 20 | - | - | - | - | - | -
31 | u | Uncovered |  |  |  |  | - | - | - | - | - | - | - | - | - | - | -
 | Wooksheets Required
 | Week Commencing |  |  | 2013-10-30 00:00:00
 | 812409 | S Barber |  | CP2
 | 533497 | R Miller |  | CS1
 | 226967 | D MacQueen |  | CS2
 | 134948 | R Gillis |  | CP1
 | 516643 | R Carr |  | A
 | 528648 | M Keast |  | B
 | 530504 | M Limon |  | C
 | 741078 | A Dray |  | 1
 | 826406 | A Hatch |  | F1
 | 317947 | J [NAME] |  | L
 | 539671 | A.Saunders |  | L
 | 206953 | K Phelan |  | P4
 | 115862 | C Canhan |  | F2
 | 104159 | A [NAME] |  | AB
 | 128557 | M Bindoraho |  | F3
 | 771140 | C Smith |  | 19
 | 885369 | R Price |  | 18
 | 154218 | L Rosier |  | P5
 | 142354 | R Murray |  | P6
 | 169566 | N Wilson |  | P3
 | 169565 | S Amadio |  | P2
 | 318474 | P Thomson |  | SL
 | 101770 | J [NAME] |  | -
 |  |  |  | -
 | u | Uncovered |  | P1
 | u | Uncovered |  | P7
 | u | Uncovered |  | 20
 | u | Uncovered |  | -
 | u | Uncovered |  | -
 | u | Uncovered |  | -