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

Wednesday
 |  |  |  | Date | 2013-10-30 00:00:00 |  |  |  | CS 5/13
Staff | Name | Key | Rostered Shift | Overtime | Remarks - Reason For Overtime
Number
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] sum for columns A and B to match staff number and name from column C
226967 | D MacQueen | CS2 | 0430-1230
516643 | R Carr | A | 0345-1345 | 1345-1400 |  |  |  |  |  |  |  |  | TheVlookup in column b works from matching column A, but I cannot get it to work when I try to get it to match with column C
u | Uncovered | P7 | 0445-0900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
169565 | S Amadio | P2 | 0445-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169565 | 169565
741078 | A Dray | 1 | 0430-1230
826406 | A Hatch | F1 | 0445-1245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406
885369 | R Price | 18 | 0845-1415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 885369 | 885369
134948 | R Gillis | CP1 | 0930-1445
128557 | M Bindoraho | F3 | 0945-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128557
169566 | N Wilson | P3 | 1400-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169566 | 169566
154218 | L Rosier | P5 | 1415-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154218 | 154218
142354 | R Murray | P6 | 1500-2215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142354 | 142354
528648 | M Keast | B | 1415-2215 | 1245-1415
812409 | S Barber | CP2 | 1430-2000
104159 | A [NAME] | AB | 0800-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104159
Rostered Off
 |  |  |  | O/T Avail ?
533497 | R Miller | CS1 | OFF
530504 | M Limon | C | OFF
115862 | C Canhan | F2 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115862
u | Uncovered | P1 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
206953 | K Phelan | P4 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206953
u | Uncovered | 20 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
771140 | C Smith | 19 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 771140
 |  | QC1 | OFF
 |  | QC2 | OFF
Wooksheets Required
Week Commencing
Number | Name |  | 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 |  | -