Spreadsheet: 822859d1679573013-match-person-based-on-date-postcode-to-a-location-date-postcode-matchmaker
Sheet: Raw data

Date | Location | Person | Postcode | [NAME] | l1 |  | Desired results → | Date | Location | Person | Postcode | [NAME]
2023-04-22 00:00:00 | Ashton |  | OL |  |  |  |  | 2023-04-29 00:00:00 | Ashton | [NAME] | OL | 45045OL
2023-04-27 00:00:00 | Ashton |  | OL |  |  |  |  | 2023-04-29 00:00:00 | Wednesfield | [NAME] | WV | 45045WV
2023-04-29 00:00:00 | Ashton |  | OL |  |  |  |  | 2023-05-06 00:00:00 | Wednesfield | [NAME] | WV | 45052WV
2023-05-02 00:00:00 | Ashton |  | OL |  |  |  |  | 2023-05-08 00:00:00 | Wednesfield | [NAME] | WV | 45054WV
2023-05-03 00:00:00 | Ashton |  | OL |  |  |  |  | 2023-03-25 00:00:00 | Westbury | [NAME] | ST | 45010ST
2023-03-31 00:00:00 | Tettenhall |  | WV |  |  |  |  | plus these
2023-03-31 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-04 00:00:00 | Wednesfield | [NAME] | WV | not sure how/ what would need be in this column and so just some notes below
2023-04-06 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-04 00:00:00 | Wednesbury | [NAME] | WV
2023-04-19 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-05 00:00:00 | Wednesfield | [NAME] | WV
2023-04-21 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-05 00:00:00 | Wednesfield | [NAME] | WV
2023-04-21 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-09 00:00:00 | Wednesfield | [NAME] | WV
2023-04-22 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-09 00:00:00 | Wolverhampton 9 | [NAME] | WV
2023-04-23 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-05-09 00:00:00 | Wednesfield | [NAME] | WV
2023-04-24 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-04-22 00:00:00 | Ashton | [NAME] | * | * indicate [NAME] would work any postcode
2023-04-26 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-04-22 00:00:00 | Wednesfield | [NAME] | *
2023-04-28 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-04-22 00:00:00 | Plymouth | [NAME] | *
2023-04-29 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-04-22 00:00:00 | Plymouth | [NAME] | PL, WV | [NAME] would work at a range of postcodes listed i.e. PL and WV but not OL of Ashton
2023-05-02 00:00:00 | Wednesfield |  | WV |  |  |  |  | 2023-04-22 00:00:00 | Ashton | [NAME] | PL, WV
2023-05-02 00:00:00 | Wednesfield |  | WV
2023-05-03 00:00:00 | Wednesfield |  | WV
2023-05-03 00:00:00 | Wednesfield |  | WV
2023-05-04 00:00:00 | Wednesfield |  | WV
2023-05-04 00:00:00 | Wednesbury |  | WV
2023-05-05 00:00:00 | Wednesfield |  | WV
2023-05-05 00:00:00 | Wednesfield |  | WV
2023-05-06 00:00:00 | Wednesfield |  | WV
2023-05-08 00:00:00 | Wednesfield |  | WV
2023-05-09 00:00:00 | Wednesfield |  | WV
2023-05-09 00:00:00 | Wolverhampton 9 |  | WV
2023-05-09 00:00:00 | Wednesfield |  | WV
2023-05-10 00:00:00 | Wednesfield |  | WV
2023-05-10 00:00:00 | Wednesfield |  | WV
2023-03-25 00:00:00 | Westbury |  | ST
2023-03-27 00:00:00 | Willenhall |  | WV
2023-04-04 00:00:00 | Willenhall |  | WV
2023-04-06 00:00:00 | Willenhall |  | WV
2023-04-11 00:00:00 | Willenhall |  | WV
2023-04-18 00:00:00 | Willenhall |  | WV
2023-04-24 00:00:00 | Willenhall |  | WV
2023-04-29 00:00:00 |  | [NAME] | OL
2023-07-05 00:00:00 | Plymouth |  | PL
2023-07-06 00:00:00 | Plymouth |  | PL
2023-04-29 00:00:00 |  | [NAME] | WV
2023-05-04 00:00:00 |  | [NAME] | WV
2023-05-05 00:00:00 |  | [NAME] | WV
2023-05-06 00:00:00 |  | [NAME] | WV
2023-05-07 00:00:00 |  | [NAME] | WV
2023-05-08 00:00:00 |  | [NAME] | WV
2023-05-09 00:00:00 |  | [NAME] | WV
2023-03-25 00:00:00 |  | [NAME] | ST
2023-04-22 00:00:00 |  | [NAME] | *
2023-04-22 00:00:00 | Plymouth |  | PL
2023-04-22 00:00:00 |  | [NAME] | PL, WV