Spreadsheet: 59342d1259839438-vlookup-within-vlookups-new-copy
Sheet: customer_addresses

TEST1 | TEST1 | TEST1 | TEST1 | TEST1 | TEST1 | TEST1 |  | Caroline Devereux | [NAME] | Geoff Eade | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] |  | [NAME] | [NAME] |  |  | Consignee | CUSTOMER A | Test2 | Test20 | CUSTOMER B | Test30
TEST2 | TEST2 | TEST2 | TEST2 | TEST2 | TEST2 | TEST2 |  |  |  | Stuart Eade |  |  |  |  | [NAME] |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  | Consignee |  | Test3 | Test21 |  | Test31
TEST3 | TEST3 | TEST3 | TEST3 | TEST3 | TEST3 | TEST3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test4 | Test22 |  | Test32
TEST4 | TEST4 | TEST4 | TEST4 | TEST4 | TEST4 | TEST4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test5 | Test23 |  | Test33
TEST5 | TEST5 | TEST5 | TEST5 | TEST5 | TEST5 | TEST5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test6 | Test24 |  | Test34
TEST6 | TEST6 | TEST6 | TEST6 | TEST6 | TEST6 | TEST6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | CMA CGM | CMA-CGM
TEST7 | TEST7 | TEST7 | TEST7 | TEST7 | TEST7 | TEST7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Line |  | CMA CGM | CMA-CGM
TEST8 | TEST8 | TEST8 | TEST8 | TEST8 | TEST8 | TEST8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost In
TEST9 | TEST9 | TEST9 | TEST9 | TEST9 | TEST9 | TEST9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify |  |  |  |  | Mr [NAME]
TEST10 | TEST10 | TEST10 | TEST10 | TEST10 | TEST10 | TEST10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST11 | TEST11 | TEST11 | TEST11 | TEST11 | TEST11 | TEST11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST12 | TEST12 | TEST12 | TEST12 | TEST12 | TEST12 | TEST12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST13 | TEST13 | TEST13 | TEST13 | TEST13 | TEST13 | TEST13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST14 | TEST14 | TEST14 | TEST14 | TEST14 | TEST14 | TEST14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST15 | TEST15 | TEST15 | TEST15 | TEST15 | TEST15 | TEST15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST16 | TEST16 | TEST16 | TEST16 | TEST16 | TEST16 | TEST16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST17 | TEST17 | TEST17 | TEST17 | TEST17 | TEST17 | TEST17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST18 | TEST18 | TEST18 | TEST18 | TEST18 | TEST18 | TEST18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Departs |  | Southampton | Southampton |  | LHR - Heathrow
TEST19 | TEST19 | TEST19 | TEST19 | TEST19 | TEST19 | TEST19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arrives |  | Malta Freeport | [NAME] |  | CAI - Cairo
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Destination |  |  |  |  | Hurghada
TEST21 | TEST21 | TEST21 | TEST21 | TEST21 | TEST21 | TEST21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Freight Payabe |  | Destination | United Kingdom |  | United Kingdom
TEST22 | TEST22 | TEST22 | TEST22 | TEST22 | TEST22 | TEST22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Charges Payable |  | Destination | United Kingdom |  | United Kingdom
TEST23 | TEST23 | TEST23 | TEST23 | TEST23 | TEST23 | TEST23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's |  | Fully Addressed | Fully Addressed |  | Fully Addressed
TEST24 | TEST24 | TEST24 | TEST24 | TEST24 | TEST24 | TEST24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's
TEST25 | TEST25 | TEST25 | TEST25 | TEST25 | TEST25 | TEST25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's
TEST26 | TEST26 | TEST26 | TEST26 | TEST26 | TEST26 | TEST26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Marks and No's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages |  |  | 1 x 20' Container
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages |  |  | Containing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages |  |  | Foodstuffs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No and Kind of Packages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DUCR No |  | 9GB927150139000- | 9GB927150139000-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Bills of Lading |  | Express | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out |  | 65 | 1110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost out
 | ALEPH_EUROPE
 | ARNOLD_ENGINEERING
 | AGL