Spreadsheet: 456735d1461022459-vlookup-not-working-when-data-in-array-is-not-in-sequential-order-customer-db-and-invoices-test
Sheet: Customer_Data

Client # | First Name | Last Name | Company | Address 1 | Address 2 | Address 3 | County | Postcode | Telephone | Mobile | [NAME] | [NAME]
1 | Test1 | User1 | Company1 | Address1 | Address2 | Address3 | County1 | PC1 | T1 | M1 | E1
2 | Test2 | User2 | Company2 | Address1 | Address2 | Address3 | County2 | PC2 | T2 | M2 | E2
3 | Test3 | User3 | Company3 | Address1 | Address2 | Address3 | County3 | PC3 | T3 | M3 | E3
4 | Test4 | User4 | Company4 | Address1 | Address2 | Address3 | County4 | PC4 | T4 | M4 | E4
5 | Test5 | [NAME] | Company5 | Address1 | Address2 | Address3 | County5 | PC5 | T5 | M5 | E5
6 | Test6 | [NAME] | Company6 | Address1 | Address2 | Address3 | County6 | PC6 | T6 | M6 | E6
7 | [NAME] | User7 | Company7 | Address1 | Address2 | Address3 | County7 | PC7 | T7 | M7 | E7
8 | Test8 | User8 | Company8 | Address1 | Address2 | Address3 | County8 | PC8 | T8 | M8 | E8
9 | Test9 | [NAME] | Company9 | Address1 | Address2 | Address3 | County9 | PC9 | T9 | M9 | E9
10 | Test10 | User10 | Company10 | Address1 | Address2 | Address3 | County10 | PC10 | T10 | M10 | E10
11 | Test11 | User11 | Company11 | Address1 | Address2 | Address3 | County11 | PC11 | T11 | M11 | E11
12 | Test12 | User12 | Company12 | Address1 | Address2 | Address3 | County12 | PC12 | T12 | M12 | E12
13 | Test13 | User13 | Company13 | Address1 | Address2 | Address3 | County13 | PC13 | T13 | [NAME] | [NAME]
14 | Test14 | User14 | Company14 | Address1 | Address2 | Address3 | County14 | PC14 | T14 | M14 | E14
15 | Test15 | User15 | Company15 | Address1 | Address2 | Address3 | County15 | PC15 | T15 | M15 | E15
16 | Test16 | User16 | Company16 | Address1 | Address2 | Address3 | County16 | PC16 | T16 | M16 | E16
17 | Test17 | User17 | Company17 | Address1 | Address2 | Address3 | County17 | PC17 | T17 | [NAME] | E17
18 | Test18 | User18 | Company18 | Address1 | Address2 | Address3 | County18 | PC18 | T18 | M18 | E18
19 | Test19 | User19 | Company19 | Address1 | Address2 | Address3 | County19 | PC19 | T19 | M19 | E19
20 | Test20 | User20 | Company20 | Address1 | Address2 | Address3 | County20 | PC20 | T20 | M20 | E20
21 | Test21 | User21 | Company21 | Address1 | Address2 | Address3 | County21 | PC21 | T21 | M21 | E21
22 | Test22 | User22 | Company22 | Address1 | Address2 | Address3 | County22 | PC22 | T22 | M22 | E22
23 | Test23 | User23 | Company23 | Address1 | Address2 | Address3 | County23 | PC23 | T23 | M23 | E23
24 | Test24 | User24 | Company24 | Address1 | Address2 | Address3 | County24 | PC24 | T24 | M24 | E24
25 | [NAME] | User25 | Company25 | Address1 | Address2 | Address3 | County25 | PC25 | T25 | M25 | E25
26 | Test26 | User26 | Company26 | Address1 | Address2 | Address3 | County26 | PC26 | T26 | M26 | E26
27 | Test27 | User27 | Company27 | Address1 | Address2 | Address3 | County27 | PC27 | T27 | M27 | E27
28 | Test28 | User28 | Company28 | Address1 | Address2 | Address3 | County28 | PC28 | T28 | M28 | E28
29 | Test29 | User29 | Company29 | Address1 | Address2 | Address3 | County29 | PC29 | T29 | M29 | E29
30 | Test30 | User30 | Company30 | Address1 | Address2 | Address3 | County30 | PC30 | T30 | M30 | E30
31 | Test31 | User31 | Company31 | Address1 | Address2 | Address3 | County31 | PC31 | T31 | M31 | E31
32 | Test32 | User32 | Company32 | Address1 | Address2 | Address3 | County32 | PC32 | T32 | M32 | E32
33 | Test33 | User33 | Company33 | Address1 | Address2 | Address3 | County33 | PC33 | T33 | M33 | E33
34 | Test34 | User34 | Company34 | Address1 | Address2 | Address3 | County34 | PC34 | T34 | M34 | E34
35 | Test35 | User35 | Company35 | Address1 | Address2 | Address3 | County35 | PC35 | T35 | M35 | E35
36 | Test36 | User36 | Company36 | Address1 | Address2 | Address3 | County36 | PC36 | T36 | M36 | E36
37 | Test37 | User37 | Company37 | Address1 | Address2 | Address3 | County37 | PC37 | T37 | M37 | E37
38 | Test38 | User38 | Company38 | Address1 | Address2 | Address3 | County38 | PC38 | T38 | M38 | E38
39 | Test39 | User39 | Company39 | Address1 | Address2 | Address3 | County39 | PC39 | T39 | M39 | E39
40 | Test40 | User40 | Company40 | Address1 | Address2 | Address3 | County40 | PC40 | T40 | M40 | E40
41 | Test41 | [NAME] | Company41 | Address1 | Address2 | Address3 | County41 | PC41 | T41 | M41 | E41
42 | Test42 | User42 | Company42 | Address1 | Address2 | Address3 | County42 | PC42 | T42 | M42 | E42
43 | Test43 | User43 | Company43 | Address1 | Address2 | Address3 | County43 | PC43 | T43 | M43 | E43
44 | Test44 | User44 | Company44 | Address1 | Address2 | Address3 | County44 | PC44 | T44 | M44 | E44 | Second contact - Ms E Detiger
45 | Test45 | User45 | Company45 | Address1 | Address2 | Address3 | County45 | PC45 | T45 | M45 | E45
46 | Test46 | User46 | Company46 | Address1 | Address2 | Address3 | County46 | PC46 | T46 | M46 | E46
47 | Test47 | User47 | Company47 | Address1 | Address2 | Address3 | County47 | PC47 | T47 | M47 | E47
48 | Test48 | User48 | Company48 | Address1 | Address2 | Address3 | County48 | PC48 | T48 | M48 | E48
49 | Test49 | User49 | Company49 | Address1 | Address2 | Address3 | County49 | PC49 | T49 | M49 | E49
50 | Test50 | User50 | Company50 | Address1 | Address2 | Address3 | County50 | PC50 | T50 | M50 | E50
51 | Test51 | [NAME] | Company51 | Address1 | Address2 | Address3 | County51 | PC51 | T51 | M51 | E51
52 | Test52 | User52 | Company52 | Address1 | Address2 | Address3 | County52 | PC52 | T52 | M52 | [NAME]
53 | Test53 | [NAME] | Company53 | Address1 | Address2 | Address3 | County53 | PC53 | T53 | M53 | E53
54 | Test54 | User54 | Company54 | Address1 | Address2 | Address3 | County54 | PC54 | T54 | M54 | E54
55 | Test55 | User55 | Company55 | Address1 | Address2 | Address3 | County55 | PC55 | T55 | M55 | E55
56 | Test56 | User56 | Company56 | Address1 | Address2 | Address3 | County56 | PC56 | T56 | M56 | E56
57 | Test57 | User57 | Company57 | Address1 | Address2 | Address3 | County57 | PC57 | T57 | M57 | E57
58 | Test58 | User58 | Company58 | Address1 | Address2 | Address3 | County58 | PC58 | T58 | M58 | E58
59 | Test59 | User59 | Company59 | Address1 | Address2 | Address3 | County59 | PC59 | T59 | M59 | E59
60 | Test60 | User60 | Company60 | Address1 | Address2 | Address3 | County60 | PC60 | T60 | M60 | E60
61 | Test61 | User61 | Company61 | Address1 | Address2 | Address3 | County61 | PC61 | T61 | M61 | E61
62 | Test62 | User62 | Company62 | Address1 | Address2 | Address3 | County62 | PC62 | [NAME] | M62 | E62
63 | Test63 | User63 | Company63 | Address1 | Address2 | Address3 | County63 | PC63 | T63 | M63 | E63
64 | Test64 | User64 | Company64 | Address1 | Address2 | Address3 | County64 | PC64 | T64 | M64 | E64
65 | Test65 | User65 | Company65 | Address1 | Address2 | Address3 | County65 | PC65 | T65 | M65 | E65
66 | Test66 | User66 | Company66 | Address1 | Address2 | Address3 | County66 | PC66 | T66 | M66 | E66
67 | Test67 | [NAME] | Company67 | Address1 | Address2 | Address3 | County67 | PC67 | T67 | M67 | E67
68 | Test68 | User68 | Company68 | Address1 | Address2 | Address3 | County68 | PC68 | T68 | M68 | E68
69 | Test69 | User69 | Company69 | Address1 | Address2 | Address3 | County69 | PC69 | T69 | M69 | E69
70 | Test70 | User70 | Company70 | Address1 | Address2 | Address3 | County70 | PC70 | T70 | M70 | E70
71 | Test71 | User71 | Company71 | Address1 | Address2 | Address3 | County71 | PC71 | T71 | M71 | E71
72 | Test72 | User72 | Company72 | Address1 | Address2 | Address3 | County72 | PC72 | T72 | M72 | E72
73 | Test73 | User73 | Company73 | Address1 | Address2 | Address3 | County73 | PC73 | T73 | M73 | E73
74 | Test74 | User74 | Company74 | Address1 | Address2 | Address3 | County74 | PC74 | T74 | M74 | E74
75 | Test75 | [NAME] | Company75 | Address1 | Address2 | Address3 | County75 | PC75 | T75 | M75 | E75
76 | Test76 | User76 | Company76 | Address1 | Address2 | Address3 | County76 | PC76 | T76 | M76 | E76
77 | Test77 | User77 | Company77 | Address1 | Address2 | Address3 | County77 | PC77 | T77 | M77 | E77
78 | Test78 | User78 | Company78 | Address1 | Address2 | Address3 | County78 | PC78 | T78 | M78 | E78
79 | Test79 | User79 | Company79 | Address1 | Address2 | Address3 | County79 | PC79 | T79 | M79 | E79
80 | Test80 | User80 | Company80 | Address1 | Address2 | Address3 | County80 | PC80 | T80 | M80 | E80
81 | Test81 | User81 | Company81 | Address1 | Address2 | Address3 | County81 | PC81 | T81 | M81 | E81
82 | Test82 | User82 | Company82 | Address1 | Address2 | Address3 | County82 | PC82 | T82 | M82 | E82
83 | Test83 | User83 | Company83 | Address1 | Address2 | Address3 | County83 | PC83 | T83 | M83 | E83
84 | Test84 | User84 | Company84 | Address1 | Address2 | Address3 | County84 | PC84 | T84 | M84 | E84
85 | Test85 | User85 | [NAME] | Address1 | Address2 | Address3 | County85 | PC85 | T85 | M85 | [NAME]
86 | Test86 | User86 | Company86 | Address1 | Address2 | Address3 | County86 | PC86 | T86 | [NAME] | E86
87 | Test87 | User87 | Company87 | Address1 | Address2 | Address3 | County87 | PC87 | T87 | M87 | E87