Spreadsheet: 97323d1296539095-joining-columns-of-different-lengths-from-different-sheets-array3dvlookup
Sheet: Summary

1 | code1 | Name1 | Addr1 | City1 | Zip1 | Phone1 |  |  |  |  |  |  |  | Sheet1
2 | code2 | [NAME] | Addr2 | City2 | Zip2 | Phone2 |  |  |  |  |  |  |  | Sheet2
3 | code3 | Name3 | Addr3 | City3 | Zip3 | Phone3 |  |  |  |  |  |  |  | Sheet3
4 | code4 | Name4 | Addr4 | City4 | Zip4 | Phone4 |  |  |  |  |  |  |  | Sheet4
5 | code5 | Name5 | Addr5 | City5 | Zip5 | Phone5 |  |  |  |  |  |  |  | Sheet5
6 | code6 | Name6 | Addr6 | [NAME] | Zip6 | Phone6 |  |  |  |  |  |  |  | Sheet6
7 | code7 | Name7 | Addr7 | City7 | Zip7 | Phone7
8 | code8 | Name8 | [NAME] | City8 | Zip8 | Phone8
9 | [NAME] | Name9 | Addr9 | City9 | Zip9 | Phone9
10 | code10 | Name10 | Addr10 | City10 | Zip10 | Phone10
11 | code11 | Name11 | Addr11 | City11 | Zip11 | Phone11
12 | code12 | Name12 | Addr12 | City12 | Zip12 | Phone12
13 | code13 | Name13 | Addr13 | City13 | [NAME] | Phone13
14 | code14 | Name14 | Addr14 | City14 | Zip14 | Phone14
15 | code15 | Name15 | Addr15 | City15 | Zip15 | Phone15
16 | [NAME] | [NAME] | Addr16 | City16 | Zip16 | Phone16
17 | code17 | Name17 | Addr17 | City17 | Zip17 | Phone17
18 | code18 | Name18 | Addr18 | City18 | Zip18 | Phone18
19 | code19 | Name19 | Addr19 | City19 | Zip19 | Phone19
20 | code20 | [NAME] | Addr20 | City20 | Zip20 | Phone20
21 | code21 | Name21 | [NAME] | City21 | [NAME] | Phone21
22 | code22 | Name22 | Addr22 | City22 | [NAME] | Phone22
23 | code23 | Name23 | Addr23 | City23 | Zip23 | Phone23
24 | code24 | Name24 | Addr24 | City24 | Zip24 | Phone24
25 | code25 | Name25 | Addr25 | City25 | Zip25 | Phone25
26 | code26 | Name26 | [NAME] | City26 | Zip26 | Phone26
27 | code27 | Name27 | Addr27 | City27 | Zip27 | Phone27
28 | code28 | Name28 | Addr28 | City28 | Zip28 | Phone28
29 | code29 | Name29 | Addr29 | City29 | Zip29 | Phone29
30 | code30 | Name30 | Addr30 | City30 | [NAME] | Phone30
31 | code31 | Name31 | Addr31 | City31 | Zip31 | Phone31
32 | code32 | Name32 | Addr32 | City32 | Zip32 | Phone32
33 | code33 | Name33 | Addr33 | City33 | Zip33 | Phone33
34 | code34 | [NAME] | Addr34 | City34 | Zip34 | Phone34
35 | code35 | Name35 | [NAME] | City35 | [NAME] | Phone35
36 | code36 | Name36 | Addr36 | City36 | Zip36 | Phone36
37 | code37 | Name37 | Addr37 | City37 | Zip37 | Phone37
38 | code38 | Name38 | Addr38 | City38 | Zip38 | Phone38
39 | code39 | [NAME] | Addr39 | City39 | Zip39 | Phone39
40 | code40 | Name40 | Addr40 | City40 | Zip40 | Phone40
41 | code41 | Name41 | Addr41 | City41 | [NAME] | Phone41
42 | code42 | Name42 | Addr42 | City42 | Zip42 | Phone42
43 | code43 | Name43 | Addr43 | City43 | Zip43 | Phone43
44 | code44 | Name44 | Addr44 | City44 | Zip44 | Phone44
45 | code45 | Name45 | Addr45 | City45 | Zip45 | Phone45
46 | code46 | Name46 | Addr46 | [NAME] | Zip46 | Phone46
47 | code47 | [NAME] | Addr47 | City47 | Zip47 | Phone47
48 | code48 | Name48 | Addr48 | City48 | Zip48 | Phone48
49 | code49 | Name49 | Addr49 | City49 | [NAME] | Phone49
50 | code50 | Name50 | Addr50 | City50 | Zip50 | Phone50
51 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
52 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
53 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
54 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
55 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
56 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
57 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
58 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A