Spreadsheet: 59431d1259930220-vlookup-within-vlookups-new-copy_new
Sheet: customer_addresses

Client | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Address 6 | Contact 1 | Contact 2 | Contact 3 | Contact 4 | Contact 5
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 | Caroline Devereux
Client 2 | Client2 [NAME] | Client2 [NAME] | Client2 [NAME] 3 | Client2 [NAME] | Client2 [NAME] 5 | Client2 [NAME] 6 | [NAME]
Client 3 | Client3 [NAME] | Client3 [NAME] | Client3 [NAME] 3 | Client3 [NAME] | Client3 Address Line 5 | Client3 [NAME] 6 | Geoff Eade | Stuart Eade
Client 4 | Client4 [NAME] 1 | Client4 [NAME] 2 | Client4 [NAME] 3 | Client4 [NAME] 4 | Client4 [NAME] 5 | Client4 [NAME] 6 | [NAME]
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 | [NAME]
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 | [NAME]
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 | [NAME] | [NAME]
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 | [NAME]
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 | [NAME] | [NAME]
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 | [NAME] | [NAME]
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 | [NAME]
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 | [NAME]
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 | [NAME] | [NAME]
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 | [NAME] | [NAME]
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 | [NAME]
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 | [NAME]
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 | [NAME]
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 | [NAME] | [NAME]
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 | [NAME] | [NAME]
 | ALEPH_EUROPE
 | ARNOLD_ENGINEERING
 | AGL