Spreadsheet: 698971d1602282494-create-a-v-look-up-on-a-seperate-sheet-to-automatically-sorts-my-data-test-data-spreadsheet
Sheet: CREWING SHEET

2020-10-10 00:00:00
COURIER TOUR | COURIER ID | COURIER | Contact Number | POSTCODES | WORKING | Red and Green | MAX | Days | COMMENTS | DELIVERY / COLLECT
LG10 | ID 1 | Name 1 | Test 1 | LS28 - 5 | YES | NO | 100 | Monday to Saturday |  | COLLECT |  | YES
LG11 | ID 2 | Name 2 | Test 2 | BD5 -7/8/9                       BD6 - 1 | YES | NO | 100 | Monday to Saturday |  | SACK POINT |  | NO
LG12 | ID 3 | Name 3 | Test 3 | BD21 - 4 | NO | NO | 75 | Monday to Saturday | NO START DATE | HOME DELIVERY
LG13 | ID 4 | Name 4 | Test 4 | BD4 - 6                                   BD11 (all) | NO | YES | 100 | Monday to Friday |  | SACK POINT
LG14 | ID 5 | Name 5 | Test 5 | BD7 - 1/2/3/4 | NO | YES | 100 | Monday to Saturday | RTW  12/10/20 | SACK POINT
[NAME] | ID 6 | Name 6 | Test 6 | [NAME] | NO | YES | 150 | Monday to Saturday |  | COLLECT
LG16 | ID 7 | Name 7 | Test 7 | S75 - 3 / 5 / 6 | NO | YES | 120 | Monday to Saturday | RTW 12/10 | HOME DELIVERY
LG17 | ID 8 | Name 8 | Test 8 | BD8 - 8/9/0 | YES | NO | 60 | Monday to Saturday | BD8-0 to LG27 | SACK POINT
LG18 | ID 9 | Name 9 | Test 9 | BD17 - 5/6/7 | NO | NO | 80 | Monday to Thursday | RTW 16/10/2020 | HOME DELIVERY
LG19 | ID 10 | Name 10 | Test 10 | BD15 - 7/8/9/0 | YES | NO | 90 | Monday to Saturday |  | SACK POINT
[NAME] | ID 11 | Name 11 | Test 11 | WF2 - 7 / 8 | YES | NO | 100 | Monday to Saturday |  | HOME DELIVERY
LG21 | ID 12 | Name 12 | Test 12 | LS11 - 5 /6/7/8/9 | NO | NO | 120 | Monday to Saturday | 70 MAX EVERY WEDNESDAY | COLLECT
LG22 | ID 13 | Name 13 | Test 13 | [NAME] | NO | NO | 80 | Monday to Friday |  | HOME DELIVERY
LG23 | ID 14 | Name 14 | Test 14 | WF16 - 9                               WF17 -  7/ 8 / 9 | NO | YES | 175 | Monday to Friday |  | COLLECT
LG24 | ID 15 | Name 15 | Test 15 | WF14 - 8 / 9 / 0 | YES | NO | 150 | Monday to Saturday |  | HOME DELIVERY
LG25 | ID 16 | Name 16 | Test 16 | ALL WF5 | NO | YES | 100 | Monday to Friday |  | COLLECT
LG26 | ID 17 | Name 17 | Test 17 | BD2 - 1                                 BD18 - 2 | YES | NO | 80 | Monday to Saturday |  | HOME DELIVERY
LG27 | ID 18 | Name 18 | Test 18 | BD13 - 1/2/3                BD14 - 6 | YES | NO | 90 | Monday to Saturday |  | SACK POINT
LG28 | ID 19 | Name 19 | Test 19 | LS5 - 3                                        LS4 - 2 /LS6-1 | YES | NO | 100 | Monday to Saturday |  | HOME DELIVERY
LG29 | ID 20 | Name 20 | Test 20 | BD2-2 / 3 / 4 | YES | NO | 70 | M/T/THU/F/S |  | SACK POINT
LG30 | ID 21 | Name 21 | Test 21 | LS27 (all) | YES | NO | 200 | Monday to Saturday |  | COLLECT
LG31 | ID 22 | Name 22 | Test 22 | BD10 - 8 / 9 / 0 | NO | NO | 60 | Tuesday to Saturday |  | SACK POINT
LG32 | ID 23 | Name 23 | Test 23 | [NAME] | NO | YES | 100 | Monday to Friday | WILL COLLECT | HOME DELIVERY
LG33 | ID 24 | Name 24 | Test 24 | WF4 - 3/4/5/6 (WF4-6 overspill to LG75) | YES | NO | 140 M-F  100 S | Monday to Saturday | WF4-6 overspill to LG75 | COLLECT
[NAME] | ID 25 | Name 25 | Test 25 | BD3 - 9 / 0 / 7 | YES | NO | 100 | Monday to Saturday |  | SACK POINT
LG35 | ID 26 | Name 26 | Test 26 | LS6 - 2 / 3 / 4 | NO | NO | 100 | Monday to Saturday |  | COLLECT
LG36 | ID 27 | Name 27 | Test 27 | BD13 - 1 / 2 | NO | YES | 50 | Monday to Friday |  | SACK POINT
LG37 | ID 28 | Name 28 | Test 28 | [NAME] | YES | NO |  | Monday to Saturday |  | COLLECT
LG38 | ID 29 | Name 29 | Test 29 | LS9 - 6 / 7 / 8 /  9 | YES | NO | 100 | Monday to Saturday |  | COLLECT
LG39 | ID 30 | Name 30 | Test 30 | LS19 - 6 | NO | NO | 50 | Monday to Saturday | CAR BREAKDOWN | HOME DELIVERY
LG40 | ID 31 | Name 31 | Test 31 | LS7 - 2 / 3 / 4 | YES | NO | 80 | Monday to Saturday |  | COLLECT
LG41 | ID 32 | Name 32 | Test 32 | BD12 - 7 / 8 / 9 / 0 | NO | YES | 100 | Monday to Friday |  | COLLECT
LG42 | ID 33 | Name 33 | Test 33 | BD16 - 1 / 2 / 4 | YES | NO | 70 | M/T/W/THU/S |  | COLLECT
[NAME] | ID 34 | Name 34 | Test 34 | BD20 - 7 / 8 | YES | NO | 30 | Monday to Saturday |  | HOME DELIVERY
LG44 | ID 35 | Name 35 | Test 35 | WF17 - 5 / 6 / 0 | YES | NO | 50 | Monday to Saturday |  | COLLECT
LG45 | ID 36 | Name 36 | Test 36 | LS16 - 8/9 | NO | NO | 50 | Monday to Saturday | NO START DATE
LG46 | ID 37 | Name 37 | Test 37 | BD13 - 4 / 5 | NO | NO | 50 | Monday to Saturday | NO START DATE | SACKPOINT |  | YES
LG47 | ID 38 | Name 38 | Test 38 | BD4 - 7 / 8 / 9 / 0 | YES | NO | 175 | Monday to Saturday |  | COLLECT |  | NO
LG48 | ID 39 | Name 39 | Test 39 | BD18 - 3/4 | NO | NO | 50 | Monday to Saturday | NO START DATE | HOME DELIVERY
LG49 | ID 40 | Name 40 | Test 40 | LS16 - 5 / 6 / 7 | NO | NO | 80 | Monday to Friday | CAR BREAKDOWN | COLLECT
LG50 | ID 41 | Name 41 | Test 41 | [NAME] | NO | NO | 50 | Monday to Friday | NO START DATE | COLLECT
LG51 | ID 42 | Name 42 | Test 42 | [NAME] 3 | NO | YES | 80 | Monday to Saturday | RTW 12/10/20 | SACKPOINT
LG52 | ID 43 | Name 43 | Test 43 | LS18 - 4 / 5                           LS19 - 7 | NO | YES | MON-WED 120                  THUR/FRI 60 | Monday to Friday | 100 THU/FRI | COLLECT
LG53 | ID 44 | Name 44 | Test 44 | LS12 - 1 / 6 | YES | NO | 60 | Monday to Saturday |  | COLLECT
LG54 | ID 45 | Name 45 | Test 45 | LS20 - 8 / 9 & LS29 - 6 | YES | NO | 150 | Monday to Saturday |  | HOME DELIVERY
LG55 | ID 46 | Name 46 | Test 46 | BD21 - 1 / 2 | YES | NO | 50 | Monday to Saturday |  | HOME DELIVERY
LG56 | ID 47 | Name 47 | Test 47 | WF1 - 2/3/4 | YES | NO | 120 | Monday to Saturday |  | COLLECT
LG57 | ID 48 | Name 48 | Test 48 | WF12 - 7 / 8 / 9 | NO | YES | 120 | Monday to Friday |  | HOME DELIVERY
LG58 | ID 49 | Name 49 | Test 49 | WF13 - 3/4                            WF16-0 | YES | NO | 120 | Monday to Saturday |  | COLLECT
LG59 | ID 50 | Name 50 | Test 50 | LS6 -1 | NO | NO | 50 | Monday to Saturday | NO START DATE
LG60 | ID 51 | Name 51 | Test 51 | WF1 - 5 / WF2 - 6 /       WF4 - 1 | YES | NO | 100 | Tuesday to Saturday |  | COLLECT
LG61 | ID 52 | Name 52 | Test 52 | BD9 - 6 | NO | NO | 50 | Monday to Saturday | NO START DATE | SACK POINT
LG62 | ID 53 | Name 53 | Test 53 | LS28 - 6/ 7 / 9 | NO | YES | 75 | Monday to Friday |  | HOME DELIVERY
LG63 | ID 54 | Name 54 | Test 54 | LS28  -  8 | NO | YES | 75 | Monday to Friday |  | COLLECT
LG64 | ID 55 | Name 55 | Test 55 | BD22 - 7 / 8 | YES | NO | 80 | Monday to Saturday |  | HOME DELIVERY
LG65 | ID 56 | Name 56 | Test 56 | WF15 - 6 / 7 / 8 | YES | NO | 80 | Monday to Saturday |  | HOME DELIVERY
LG66 | ID 57 | Name 57 | Test 57 | WF3 - 1 / 2 | YES | NO | 100 | Monday to Saturday |  | COLLECT
LG67 | ID 58 | Name 58 | Test 58 | WF3 - 3 / 4 | NO | YES | 100 | Monday to Saturday |  | COLLECT
LG68 | ID 59 | Name 59 | Test 59 | LS8 - 2 / 4 / 5 | YES | NO | 100 | Monday to Saturday | MAX NOW 100 | COLLECT
LG69 | ID 60 | Name 60 | Test 60 | LS17 - 5 / 6                      LS8-1 | YES | NO | 100 | Monday to Saturday |  | COLLECT
[NAME] | ID 61 | Name 61 | Test 61 | LS17 - 8 / 6 | NO | NO | 70 |  |  | COLLECT
LG71 | ID 62 | Name 62 | Test 62 | LS10 - 2 / 3 / 4 | YES | NO | 150 | Monday to Saturday |  | COLLECT
LG72 | ID 63 | Name 63 | Test 63 | HG1 - 3 | YES | NO | 100 | Monday to Saturday | ONLY HG1-3 | HOME DELIVERY
LG73 | ID 64 | Name 64 | Test 64 | HG1 - 4 & HG2 - 7 | YES | NO | 50 | Monday to Saturday |  | HOME DELIVERY
LG74 | ID 65 | Name 65 | Test 65 | HG2 - 9/0 | YES | NO | 50 | Tuesday to Saturday |  | HOME DELIVERY
LG75 | ID 66 | Name 66 | Test 66 | WF12 - 0 & WF4-6 (overspill from LG33) | YES | NO | 50 | Monday to Saturday |  | HOME DELIVERY |  | YES
LG76 | ID 67 | Name 67 | Test 67 | HG2 - 7 | NO | NO | 50 | Monday to Saturday |  | HOME DELIVERY |  | NO
LG77 | ID 68 | Name 68 | Test 68 | LS29 - 7 | NO | NO | 50 | Monday to Saturday | NO START DATE | HOME DELIVERY
LG78 | ID 69 | Name 69 | Test 69 | LS21 - 1 / 3 | NO | NO | 50 | Monday to Friday |  | HOMEDELIVERY
LG79 | ID 70 | Name 70 | Test 70 | [NAME] | NO | YES | 75 | Monday to Saturday | GREENS ONLY | HOME DELIVERY
[NAME] | ID 71 | Name 71 | Test 71 | BD20 - 6 / BD22 - 6 | NO | YES | 50 | Monday to Friday |  | COLLECT
LG81 | ID 72 | Name 72 | Test 72 |  | NO | NO
LG82 | ID 73 | Name 73 | Test 73 |  | NO | NO
LG83 | ID 74 | Name 74 | Test 74 |  | NO | NO
LG84 | ID 75 | Name 75 | Test 75 |  | NO | NO
LG85 | ID 76 | Name 76 | Test 76 |  | NO | NO |  |  |  |  |  | YES
LG86 | ID 77 | Name 77 | Test 77 |  | NO | NO |  |  |  |  |  | NO
LG87 | ID 78 | Name 78 | Test 78 |  | NO | NO
LG88 | ID 79 | Name 79 | Test 79 | S75 - 1 / 2 | NO | YES | 130 | Monday to Friday | RTW 12/10 | HOME DELIVERY
LG89 | ID 80 | Name 80 | Test 80 | WF2 - 0 / 9 | YES | NO | 100 | Monday to Saturday |  | HOME DELIVERY
LG99 | ID 81 | Name 81 | Test 81 | BD19 | YES | NO | 150 | Monday to Saturday |  | COLLECT
 |  |  | Couriers Working