Spreadsheet: 698981d1602296494-create-a-v-look-up-on-a-seperate-sheet-to-automatically-sorts-my-data-test-data-spreadsheet
Sheet: COURIERS OFF

 | EXAMPLE HOW I  WANT IT |  |  |  |  |  | NO
 | WORKING | POSTCODES | COURIER |  |  | WORKING | POSTCODES | COURIER
 | NO | BD21 - 4 | Name 3 |  |  |  | BD21 - 4 | Name 3
 | NO | BD4 - 6                                   BD11 (all) | Name 4 |  |  |  | BD4 - 6                                   BD11 (all) | Name 4
 | NO | BD7 - 1/2/3/4 | Name 5 |  |  |  | BD7 - 1/2/3/4 | Name 5
 | NO | [NAME] | Name 6 |  |  |  | [NAME] | Name 6
 | NO | S75 - 3 / 5 / 6 | Name 7 |  |  |  | S75 - 3 / 5 / 6 | Name 7
 |  |  |  |  |  |  | BD17 - 5/6/7 | Name 9
 |  |  |  |  |  |  | LS11 - 5 /6/7/8/9 | Name 12
 |  |  |  |  |  |  | [NAME] | Name 13
 |  |  |  |  |  |  | WF16 - 9                               WF17 -  7/ 8 / 9 | Name 14
 |  |  |  |  |  |  | ALL WF5 | Name 16
 |  |  |  |  |  |  | BD10 - 8 / 9 / 0 | Name 22
 |  |  |  |  |  |  | [NAME] | Name 23
 |  |  |  |  |  |  | LS6 - 2 / 3 / 4 | Name 26
 |  |  |  |  |  |  | BD13 - 1 / 2 | Name 27
 |  |  |  |  |  |  | LS19 - 6 | Name 30
 |  |  |  |  |  |  | BD12 - 7 / 8 / 9 / 0 | Name 32
 |  |  |  |  |  |  | LS16 - 8/9 | Name 36
 |  |  |  |  |  |  | BD13 - 4 / 5 | Name 37
 |  |  |  |  |  |  | BD18 - 3/4 | Name 39
 |  |  |  |  |  |  | LS16 - 5 / 6 / 7 | Name 40
 |  |  |  |  |  |  | [NAME] | Name 41
 |  |  |  |  |  |  | [NAME] 3 | Name 42
 |  |  |  |  |  |  | LS18 - 4 / 5                           LS19 - 7 | Name 43
 |  |  |  |  |  |  | WF12 - 7 / 8 / 9 | Name 48
 |  |  |  |  |  |  | LS6 -1 | Name 50
 |  |  |  |  |  |  | BD9 - 6 | Name 52
 |  |  |  |  |  |  | LS28 - 6/ 7 / 9 | Name 53
 |  |  |  |  |  |  | LS28  -  8 | Name 54
 |  |  |  |  |  |  | WF3 - 3 / 4 | Name 58
 |  |  |  |  |  |  | LS17 - 8 / 6 | Name 61
 |  |  |  |  |  |  | HG2 - 7 | Name 67
 |  |  |  |  |  |  | LS29 - 7 | Name 68
 |  |  |  |  |  |  | LS21 - 1 / 3 | Name 69
 |  |  |  |  |  |  | [NAME] | Name 70
 |  |  |  |  |  |  | BD20 - 6 / BD22 - 6 | Name 71
 |  |  |  |  |  |  | 0 | Name 72
 |  |  |  |  |  |  | 0 | Name 73
 |  |  |  |  |  |  | 0 | Name 74
 |  |  |  |  |  |  | 0 | Name 75
 |  |  |  |  |  |  | 0 | Name 76
 |  |  |  |  |  |  | 0 | Name 77
 |  |  |  |  |  |  | 0 | Name 78
 |  |  |  |  |  |  | S75 - 1 / 2 | Name 79
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0