Spreadsheet: 59424d1259926291-vlookup-within-vlookups-new-copy
Sheet: customer_addresses

Client 1 | Client1 Address Line 1 | Client1 Address Line 2 | Client1 Address Line 3 | Client1 Address Line 4 | Client1 Address Line 5 | Client1 Address Line 6 | Contact 1 | Caroline Devereux | [NAME] | Geoff Eade | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] |  | [NAME] | [NAME]
Client 2 | Client2 [NAME] | Client2 [NAME] | Client2 [NAME] 3 | Client2 [NAME] | Client2 [NAME] 5 | Client2 [NAME] 6 | Contact 2 |  |  | Stuart Eade |  |  |  |  | [NAME] |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  | [NAME]
Client 3 | Client3 [NAME] | Client3 [NAME] | Client3 [NAME] 3 | Client3 [NAME] | Client3 Address Line 5 | Client3 [NAME] 6 | Contact 3
Client 4 | Client4 [NAME] 1 | Client4 [NAME] 2 | Client4 [NAME] 3 | Client4 [NAME] 4 | Client4 [NAME] 5 | Client4 [NAME] 6 | Contact 4
Client 5 | Client5 Address Line 1 | Client5 Address Line 2 | Client5 Address Line 3 | Client5 Address Line 4 | Client5 Address Line 5 | Client5 Address Line 6 | Contact 5
Client 6 | Client6 Address Line 1 | Client6 Address Line 2 | Client6 Address Line 3 | Client6 Address Line 4 | Client6 Address Line 5 | Client6 Address Line 6
Client 7 | Client7 [NAME] | Client7 [NAME] | Client7 [NAME] 3 | Client7 [NAME] | Client7 [NAME] | Client7 [NAME] 6
Client 8 | Client8 [NAME] | Client8 [NAME] | Client8 [NAME] 3 | Client8 [NAME] | Client8 [NAME] | Client8 [NAME] 6
Client 9 | Client9 Address Line 1 | Client9 Address Line 2 | Client9 Address Line 3 | Client9 Address Line 4 | Client9 Address Line 5 | Client9 Address Line 6
Client 10 | Client10 Address Line 1 | Client10 Address Line 2 | Client10 Address Line 3 | Client10 Address Line 4 | Client10 Address Line 5 | Client10 Address Line 6
Client 11 | Client11 Address Line 1 | Client11 Address Line 2 | Client11 Address Line 3 | Client11 Address Line 4 | Client11 Address Line 5 | Client11 Address Line 6
Client 12 | Client12 Address Line 1 | Client12 Address Line 2 | Client12 Address Line 3 | Client12 Address Line 4 | Client12 Address Line 5 | Client12 Address Line 6
Client 13 | Client13 Address Line 1 | Client13 Address Line 2 | Client13 Address Line 3 | Client13 Address Line 4 | Client13 Address Line 5 | Client13 Address Line 6
Client 14 | Client14 Address Line 1 | Client14 Address Line 2 | Client14 Address Line 3 | Client14 Address Line 4 | Client14 Address Line 5 | Client14 Address Line 6 |  | Client 1 | client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | clientt 7
Client 15 | Client15 Address Line 1 | Client15 Address Line 2 | Client15 Address Line 3 | Client15 Address Line 4 | Client15 Address Line 5 | Client15 Address Line 6
Client 16 | Client16 Address Line 1 | Client16 Address Line 2 | Client16 Address Line 3 | Client16 Address Line 4 | Client16 Address Line 5 | Client16 Address Line 6
Client 17 | Client17 Address Line 1 | Client17 Address Line 2 | Client17 Address Line 3 | Client17 Address Line 4 | Client17 Address Line 5 | Client17 Address Line 6
Client 18 | Client 18 Address Line 1 | Client 18 Address Line 2 | Client 18 Address Line 3 | Client 18 Address Line 4 | Client 18 Address Line 5 | Client 18 Address Line 6
Client 19 | Client19 Address Line 1 | Client19 Address Line 2 | Client19 Address Line 3 | Client19 Address Line 4 | Client19 Address Line 5 | Client19 Address Line 6
Client 20 | Client20 Address Line 1 | Client20 Address Line 2 | Client20 Address Line 3 | Client20 Address Line 4 | Client20 Address Line 5 | Client20 Address Line 6
Client 21 | Client21 Address Line 1 | Client21 Address Line 2 | Client21 Address Line 3 | Client21 Address Line 4 | Client21 Address Line 5 | Client21 Address Line 6
Client 22 | Client22 Address Line 1 | Client22 Address Line 2 | Client22 Address Line 3 | Client22 Address Line 4 | Client22 Address Line 5 | Client22 Address Line 6
Client 23 | Client23 Address Line 1 | Client23 Address Line 2 | Client23 Address Line 3 | Client23 Address Line 4 | Client23 Address Line 5 | Client23 Address Line 6
Client 24 | Client24 Address Line 1 | Client24 Address Line 2 | Client24 Address Line 3 | Client24 Address Line 4 | Client24 Address Line 5 | Client24 Address Line 6
Client 25 | Client25 Address Line 1 | Client25 Address Line 2 | Client25 Address Line 3 | Client25 Address Line 4 | Client25 Address Line 5 | Client25 Address Line 6
Client 26 | Client26 Address Line 1 | Client26 Address Line 2 | Client26 Address Line 3 | Client26 Address Line 4 | Client26 Address Line 5 | Client26 Address Line 6
Client 1 Consignee's
Client 1 Consignee A | Client 1 Consignee A Address 1 | Client 1 Consignee A Address 2 | Client 1 Consignee A Address 3 | Client 1 Consignee A Address 4 | Client 1 Consignee A Address 5 | Client 1 Consignee A Address 6 | Hands Transport | CMA CGM | Client 1 Consignee A Notify 1 | Client 1 Consignee A Notify 2 | Client 1 Consignee A Notify 3 | Client 1 Consignee A Notify 4 | Client 1 Consignee A Notify 5 | Client 1 Consignee A Notify 6
Client 1 Consignee B | Client 1 Consignee B Address 1 | Client 1 Consignee B Address 2 | Client 1 Consignee B Address 3 | Client 1 Consignee B Address 4 | Client 1 Consignee B Address 5 | Client 1 Consignee B Address 6 | WM International | CMA CGM | Client 2 Consignee B Notify 1 | Client 2 Consignee B Notify 2 | Client 2 Consignee B Notify 3 | Client 2 Consignee B Notify 4 | Client 2 Consignee B Notify 5 | Client 2 Consignee B Notify 6
Client 1 Consignee C | Client 1 Consignee C Address 1 | Client 1 Consignee C Address 2 | Client 1 Consignee C Address 3 | Client 1 Consignee C Address 4 | Client 1 Consignee C Address 5 | Client 1 Consignee C Address 6 | WM International | [NAME] | Client 3 Consignee C Notify 1 | Client 3 Consignee C Notify 2 | Client 3 Consignee C Notify 3 | Client 3 Consignee C Notify 4 | Client 3 Consignee C Notify 5 | Client 3 Consignee C Notify 6
Client 2 Consignee's
Client 2 Consignee A
Client 2 Consignee B
Client 2 Consginee C
Client 3 Consignee's
 | ALEPH_EUROPE
 | ARNOLD_ENGINEERING
 | AGL