Spreadsheet: 275249-vlookup-help-roster-query2-elb
Sheet: Roster

 | Ref: | CS 5/13
Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday
 | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T
CS2 | 0430-1230 |  |  | CS1 | 0430-1430 |  |  | CS1 | 0430-1430 |  |  | CP2 | 0430-1145 |  |  | CP2 | 0515-1215 |  |  | CS1 | 0430-1430 |  |  | CS1 | 0430-1430
A | 0345-1345 | 1345-1400 |  | A | 0345-1345 | 1345-1415 |  | C | 0345-1145 | 1145-1215 |  | C | 0430-1230 | 1230-1430 |  | C | 0515-1315 |  |  | C | 0345-1145 | 1145-1230 |  | C | 0345-1145 | 1145-1230
P7 | 0445-0900 |  |  | P7 | 0445-0900 |  |  | P7 | 0445-1200 |  |  | 20 | 0445-1145 |  |  | F1 | 0515-1145 |  |  | P1 | 0445-1145 |  |  | P1 | 0445-1130
P2 | 0445-1200 |  |  | P2 | 0445-1200 |  |  | P1 | 0445-1145 |  |  | P1 | 0445-0845 |  |  | P7 | 0515-1145 |  |  | P2 | 0445-1200 |  |  | 19 | 0445-1200
1 | 0430-1230 |  |  | F1 | 0445-1230 |  |  | 1 | 0430-1230 |  |  | P7 | 0445-0845 |  |  | P1 | 0700-1130 |  |  | 1 | 0430-1230 |  |  | 1 | 0430-1230
F1 | 0445-1245 |  |  | 1 | 0430-1230 |  |  | F1 | 0445-1430 |  |  | F1 | 0430-1230 |  |  | F2 | 1130-1930 |  |  | F3 | 0445-1445 |  |  | F3 | 0445-1445
18 | 0845-1415 |  |  | 18 | 0845-1415 |  |  | 18 | 0845-1415 |  |  | F2 | 1030-1830 |  |  | P6 | 1230-1630 |  |  | CP2 | 0900-1300 |  |  | CP2 | 0900-1300
CP1 | 0930-1445 |  |  | CP1 | 0930-1330 |  |  | P6 | 1300-1945 |  |  | P4 | 1230-1645 |  |  | P4 | 1300-1945 |  |  | 19 | 0930-1645 |  |  | 20 | 1245-1945
F3 | 0945-1945 |  |  | F3 | 0945-1945 |  |  | CP1 | 0930-1330 |  |  | P6 | 1300-1700 |  |  | P3 | 1500-1945 |  |  | P5 | 1245-1945 |  |  | F2 | 1145-1945 | 1000-1145
P3 | 1400-1945 |  |  | 20 | 1345-1945 |  |  | P4 | 1245-2015 |  |  | P3 | 1700-2215 |  |  | 19 | 1645-2215 |  |  | F2 | 1415-2215 |  |  | P2 | 1330-1730
P5 | 1415-1945 |  |  | P6 | 1400-1945 |  |  | P3 | 1430-1945 |  |  | B | 1415-2215 |  |  | B | 1415-2215 | 1300-1415 |  | P4 | 1500-1945 |  |  | P5 | 1215-1945
P6 | 1500-2215 |  |  | P3 | 1500-2215 |  |  | F2 | 1415-2215 |  |  | CS2 | 1045-1845 |  |  | CS2 | 1200-2000 |  |  | A | 1215-2215 |  |  | P4 | 1800-2215
B | 1415-2215 | 1245-1415 |  | B | 1415-2215 | 1400-1415 |  | B | 1415-2215 | 1200-1415 |  |  |  |  |  |  |  |  |  | CP1 | 1415-2000 |  |  | A | 1215-2215
CP2 | 1430-2000 |  |  | CS2 | 1200-2000 |  |  | CS2 | 1215-2015 |  |  | QC1 | 0445-1130 |  |  | QC1 | 1300-1930 |  |  |  |  |  |  | CP1 | 1415-2000
 |  |  |  |  |  |  |  | AB | 0800-1200 |  |  |  |  |  |  |  |  |  |  | QC1 | 1430-1930
AB | 0800-1200 |  |  | QC2 | 0445-1145 |  |  | QC1 | 1000-1630 |  |  |  |  |  |  |  |  |  |  | QC2 | 0445-0930 |  |  | QC2 | 0445-0930
 |  |  |  |  |  |  |  | QC2 | 0445-1145
Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday
 | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T |  |  | ROST | O/T
CS1 | OFF |  |  | CP2 | OFF |  |  | A | OFF |  |  | CS1 | OFF |  |  | CS1 | OFF |  |  | CS2 | OFF |  |  | CS2 | OFF
C | OFF |  |  | C | OFF |  |  | F3 | OFF |  |  | A | OFF |  |  | A | OFF |  |  | B | OFF |  |  | B | OFF
F2 | OFF |  |  | F2 | OFF |  |  | P2 | OFF |  |  | 1 | OFF |  |  | 1 | OFF |  |  | F1 | OFF |  |  | F1 | OFF
P1 | OFF |  |  | P1 | OFF |  |  | P5 | OFF |  |  | F3 | OFF |  |  | F3 | OFF |  |  | P3 | OFF |  |  | P3 | OFF
P4 | OFF |  |  | P4 | OFF |  |  | 19 | OFF |  |  | P2 | OFF |  |  | P2 | OFF |  |  | P6 | OFF |  |  | P6 | OFF
20 | OFF |  |  | P5 | OFF |  |  | 20 | OFF |  |  | P5 | OFF |  |  | P5 | OFF |  |  | 18 | OFF |  |  | P7 | OFF
19 | OFF |  |  | 19 | OFF |  |  | CP2 | OFF |  |  | 18 | OFF |  |  | 20 | OFF |  |  | P7 | OFF |  |  | 18 | OFF
QC1 | OFF |  |  | QC1 | OFF |  |  |  |  |  |  | 19 | OFF |  |  | 18 | OFF |  |  | 20 | OFF |  |  | QC1 | OFF
QC2 | OFF |  |  |  |  |  |  |  |  |  |  | CP1 | OFF |  |  | CP1 | OFF
 |  |  |  |  |  |  |  |  |  |  |  | QC2 | OFF |  |  | QC2 | OFF