Spreadsheet: 59343d1259841932-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 |  | consignee I2 | consignee J2 | consignee K2 | consignee L2 | consignee M2 | consignee N2 |  | [NAME] |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  | Consignee |  | Test3 | Test21 |  | Test31
TEST3 | TEST3 | TEST3 | TEST3 | TEST3 | TEST3 | TEST3 |  | consignee I3 | consignee J3 | consignee K3 | consignee L3 | consignee M3 | consignee N3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test4 | Test22 |  | Test32
TEST4 | TEST4 | TEST4 | TEST4 | TEST4 | TEST4 | TEST4 |  | consignee I4 | consignee J4 | consignee K4 | consignee [NAME] | consignee M4 | consignee N4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test5 | Test23 |  | Test33
TEST5 | TEST5 | TEST5 | TEST5 | TEST5 | TEST5 | TEST5 |  | consignee I5 | consignee J5 | consignee K5 | consignee L5 | consignee M5 | consignee N5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consignee |  | Test6 | Test24 |  | Test34
TEST6 | TEST6 | TEST6 | TEST6 | TEST6 | TEST6 | TEST6 |  | consignee I6 | consignee J6 | consignee K6 | consignee L6 | consignee M6 | consignee N6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | CMA CGM | CMA-CGM
TEST7 | TEST7 | TEST7 | TEST7 | TEST7 | TEST7 | TEST7 |  | consignee I7 | consignee J7 | consignee K7 | consignee L7 | consignee M7 | consignee N7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Line |  | CMA CGM | CMA-CGM
TEST8 | TEST8 | TEST8 | TEST8 | TEST8 | TEST8 | TEST8 |  | consignee I8 | consignee J8 | consignee K8 | consignee L8 | consignee M8 | consignee N8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost In
TEST9 | TEST9 | TEST9 | TEST9 | TEST9 | TEST9 | TEST9 |  | consignee I9 | consignee J9 | consignee K9 | consignee L9 | consignee M9 | consignee N9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify |  |  |  |  | Mr [NAME]
TEST10 | TEST10 | TEST10 | TEST10 | TEST10 | TEST10 | TEST10 |  | consignee I10 | consignee J10 | consignee K10 | consignee L10 | consignee M10 | consignee N10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST11 | TEST11 | TEST11 | TEST11 | TEST11 | TEST11 | TEST11 |  | consignee I11 | consignee J11 | consignee K11 | consignee L11 | consignee M11 | consignee N11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST12 | TEST12 | TEST12 | TEST12 | TEST12 | TEST12 | TEST12 |  | consignee I12 | consignee J12 | consignee K12 | consignee L12 | consignee M12 | consignee N12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST13 | TEST13 | TEST13 | TEST13 | TEST13 | TEST13 | TEST13 |  | consignee I13 | consignee J13 | consignee K13 | consignee [NAME] | consignee [NAME] | consignee N13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify
TEST14 | TEST14 | TEST14 | TEST14 | TEST14 | TEST14 | TEST14 |  | consignee I14 | consignee J14 | consignee K14 | consignee L14 | consignee M14 | consignee N14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST15 | TEST15 | TEST15 | TEST15 | TEST15 | TEST15 | TEST15 |  | consignee [NAME] | consignee J15 | consignee K15 | consignee L15 | consignee M15 | consignee N15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST16 | TEST16 | TEST16 | TEST16 | TEST16 | TEST16 | TEST16 |  | consignee I16 | consignee J16 | consignee K16 | consignee L16 | consignee M16 | consignee N16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST17 | TEST17 | TEST17 | TEST17 | TEST17 | TEST17 | TEST17 |  | consignee I17 | consignee J17 | consignee K17 | consignee L17 | consignee [NAME] | consignee N17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading Cargo At
TEST18 | TEST18 | TEST18 | TEST18 | TEST18 | TEST18 | TEST18 |  | consignee I18 | consignee J18 | consignee K18 | consignee L18 | consignee M18 | consignee N18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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