Spreadsheet: 456205d1460678933-help-adapting-an-index-formula-customer-db-and-invoices
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 | House1 | [NAME] | Town1 | County1 | PC1 | TN001 | MN001 | EM001
2 | Test2 | User2 | Company2 | House2 | Road2 | Town2 | County2 | PC2 | TN002 | MN002 | EM002
3 | Test3 | User3 | Company3 | House3 | [NAME] | Town3 | County3 | PC3 | TN003 | MN003 | EM003
4 | Test4 | User4 | Company4 | House4 | Road4 | Town4 | County4 | PC4 | TN004 | MN004 | EM004
5 | Test5 | [NAME] | Company5 | House5 | Road5 | Town5 | County5 | PC5 | TN005 | MN005 | [NAME]
6 | Test6 | [NAME] | Company6 | House6 | Road6 | Town6 | County6 | PC6 | TN006 | MN006 | EM006
7 | [NAME] | User7 | Company7 | House7 | Road7 | Town7 | County7 | PC7 | TN007 | [NAME] | EM007
8 | Test8 | User8 | Company8 | House8 | Road8 | Town8 | County8 | PC8 | TN008 | MN008 | EM008
9 | Test9 | [NAME] | Company9 | House9 | Road9 | Town9 | County9 | PC9 | TN009 | MN009 | EM009
10 | Test10 | User10 | Company10 | House10 | Road10 | Town10 | County10 | PC10 | [NAME] | MN010 | EM010
11 | Test11 | User11 | Company11 | House11 | Road11 | Town11 | County11 | PC11 | TN011 | MN011 | EM011
12 | Test12 | User12 | Company12 | House12 | Road12 | Town12 | County12 | PC12 | TN012 | MN012 | EM012
13 | Test13 | User13 | Company13 | House13 | Road13 | [NAME] | County13 | PC13 | [NAME] | MN013 | EM013
14 | Test14 | User14 | Company14 | House14 | Road14 | [NAME] | County14 | PC14 | TN014 | [NAME] | EM014
15 | Test15 | User15 | Company15 | House15 | Road15 | Town15 | County15 | PC15 | [NAME] | MN015 | EM015
16 | Test16 | User16 | Company16 | House16 | Road16 | Town16 | County16 | PC16 | TN016 | MN016 | EM016
17 | Test17 | User17 | Company17 | House17 | Road17 | Town17 | County17 | PC17 | TN017 | MN017 | EM017
18 | Test18 | User18 | Company18 | House18 | Road18 | Town18 | County18 | PC18 | TN018 | MN018 | EM018
19 | Test19 | User19 | Company19 | House19 | Road19 | Town19 | County19 | PC19 | TN019 | MN019 | EM019
20 | Test20 | User20 | Company20 | House20 | Road20 | Town20 | County20 | PC20 | TN020 | MN020 | EM020
21 | Test21 | User21 | Company21 | House21 | Road21 | Town21 | County21 | PC21 | TN021 | MN021 | EM021
22 | Test22 | User22 | Company22 | House22 | Road22 | Town22 | County22 | PC22 | TN022 | MN022 | [NAME]
23 | Test23 | User23 | Company23 | House23 | Road23 | Town23 | County23 | PC23 | TN023 | MN023 | EM023
24 | Test24 | User24 | Company24 | House24 | Road24 | Town24 | County24 | PC24 | TN024 | MN024 | EM024
25 | [NAME] | User25 | Company25 | House25 | Road25 | Town25 | County25 | PC25 | TN025 | MN025 | EM025
26 | Test26 | User26 | Company26 | House26 | Road26 | Town26 | County26 | PC26 | [NAME] | MN026 | EM026
27 | Test27 | User27 | Company27 | House27 | Road27 | Town27 | County27 | PC27 | TN027 | MN027 | EM027
28 | Test28 | User28 | Company28 | House28 | Road28 | Town28 | County28 | PC28 | TN028 | MN028 | EM028
29 | Test29 | User29 | Company29 | House29 | Road29 | Town29 | County29 | PC29 | TN029 | MN029 | EM029
30 | Test30 | User30 | Company30 | House30 | [NAME] | Town30 | County30 | PC30 | TN030 | MN030 | EM030
31 | Test31 | User31 | Company31 | House31 | Road31 | Town31 | County31 | PC31 | TN031 | MN031 | EM031
32 | Test32 | User32 | Company32 | House32 | [NAME] | Town32 | County32 | PC32 | TN032 | MN032 | EM032
33 | Test33 | User33 | Company33 | House33 | Road33 | Town33 | County33 | PC33 | TN033 | MN033 | EM033
34 | Test34 | User34 | Company34 | House34 | Road34 | Town34 | County34 | PC34 | TN034 | MN034 | EM034
35 | Test35 | User35 | Company35 | House35 | Road35 | Town35 | County35 | PC35 | TN035 | MN035 | EM035
36 | Test36 | User36 | Company36 | House36 | Road36 | Town36 | County36 | PC36 | TN036 | MN036 | EM036
37 | Test37 | User37 | Company37 | House37 | Road37 | Town37 | County37 | PC37 | TN037 | MN037 | EM037
38 | Test38 | User38 | Company38 | House38 | Road38 | Town38 | County38 | PC38 | TN038 | [NAME] | EM038
39 | Test39 | User39 | Company39 | House39 | Road39 | Town39 | County39 | PC39 | TN039 | MN039 | EM039
40 | Test40 | User40 | Company40 | House40 | Road40 | Town40 | County40 | PC40 | TN040 | MN040 | EM040
41 | Test41 | [NAME] | Company41 | House41 | Road41 | Town41 | County41 | PC41 | TN041 | MN041 | EM041
42 | Test42 | User42 | Company42 | House42 | Road42 | Town42 | County42 | PC42 | TN042 | MN042 | EM042
43 | Test43 | User43 | Company43 | House43 | Road43 | Town43 | County43 | PC43 | TN043 | MN043 | EM043
44 | Test44 | User44 | Company44 | House44 | Road44 | Town44 | County44 | PC44 | TN044 | [NAME] | [NAME] | Second contact - Ms E Detiger
45 | Test45 | User45 | Company45 | House45 | [NAME] | Town45 | County45 | PC45 | TN045 | MN045 | EM045
46 | Test46 | User46 | Company46 | House46 | Road46 | Town46 | County46 | PC46 | TN046 | [NAME] | EM046
47 | Test47 | User47 | Company47 | House47 | Road47 | Town47 | County47 | PC47 | TN047 | MN047 | EM047
48 | Test48 | User48 | Company48 | House48 | Road48 | Town48 | County48 | PC48 | TN048 | MN048 | [NAME]
49 | Test49 | User49 | Company49 | House49 | Road49 | Town49 | County49 | PC49 | TN049 | [NAME] | EM049
50 | Test50 | User50 | Company50 | House50 | Road50 | Town50 | County50 | PC50 | [NAME] | [NAME] | EM050
51 | Test51 | [NAME] | Company51 | House51 | Road51 | Town51 | County51 | PC51 | TN051 | MN051 | EM051
52 | Test52 | User52 | Company52 | House52 | Road52 | Town52 | County52 | PC52 | TN052 | MN052 | EM052
53 | Test53 | [NAME] | Company53 | House53 | Road53 | Town53 | County53 | PC53 | TN053 | MN053 | EM053
54 | Test54 | User54 | Company54 | House54 | Road54 | Town54 | County54 | PC54 | TN054 | [NAME] | EM054
55 | Test55 | User55 | Company55 | House55 | Road55 | Town55 | County55 | PC55 | TN055 | MN055 | [NAME]
56 | Test56 | User56 | Company56 | House56 | Road56 | [NAME] | County56 | PC56 | TN056 | MN056 | EM056
57 | Test57 | User57 | Company57 | House57 | Road57 | Town57 | County57 | PC57 | TN057 | MN057 | EM057
58 | Test58 | User58 | Company58 | House58 | Road58 | Town58 | County58 | PC58 | TN058 | MN058 | EM058
59 | Test59 | User59 | Company59 | House59 | Road59 | Town59 | County59 | PC59 | TN059 | MN059 | EM059
60 | Test60 | User60 | Company60 | House60 | Road60 | Town60 | County60 | PC60 | TN060 | MN060 | EM060
61 | Test61 | User61 | Company61 | House61 | Road61 | Town61 | County61 | PC61 | TN061 | MN061 | EM061
62 | Test62 | User62 | Company62 | House62 | Road62 | Town62 | County62 | PC62 | TN062 | MN062 | EM062
63 | Test63 | User63 | Company63 | House63 | [NAME] | [NAME] | County63 | PC63 | [NAME] | MN063 | EM063
64 | Test64 | User64 | Company64 | House64 | [NAME] | Town64 | County64 | PC64 | TN064 | MN064 | EM064
65 | Test65 | User65 | Company65 | House65 | Road65 | Town65 | County65 | PC65 | TN065 | MN065 | EM065
66 | Test66 | User66 | Company66 | House66 | Road66 | Town66 | County66 | PC66 | TN066 | MN066 | EM066
67 | Test67 | [NAME] | Company67 | House67 | Road67 | Town67 | County67 | PC67 | TN067 | MN067 | EM067
68 | Test68 | User68 | Company68 | House68 | Road68 | Town68 | County68 | PC68 | TN068 | [NAME] | EM068
69 | Test69 | User69 | Company69 | House69 | Road69 | Town69 | County69 | PC69 | [NAME] | MN069 | EM069
70 | Test70 | User70 | Company70 | House70 | Road70 | Town70 | County70 | PC70 | TN070 | MN070 | EM070
71 | Test71 | User71 | Company71 | House71 | Road71 | Town71 | County71 | PC71 | TN071 | [NAME] | EM071
72 | Test72 | User72 | Company72 | House72 | Road72 | Town72 | County72 | PC72 | TN072 | MN072 | EM072
73 | Test73 | User73 | Company73 | House73 | Road73 | Town73 | County73 | PC73 | [NAME] | MN073 | EM073
74 | Test74 | User74 | Company74 | House74 | Road74 | Town74 | County74 | PC74 | [NAME] | MN074 | EM074
75 | Test75 | [NAME] | Company75 | House75 | Road75 | Town75 | County75 | PC75 | TN075 | MN075 | EM075
76 | Test76 | User76 | Company76 | House76 | Road76 | Town76 | County76 | PC76 | TN076 | MN076 | EM076
77 | Test77 | User77 | Company77 | House77 | Road77 | Town77 | County77 | PC77 | TN077 | MN077 | EM077
78 | Test78 | User78 | Company78 | House78 | Road78 | [NAME] | County78 | PC78 | TN078 | MN078 | EM078
79 | Test79 | User79 | Company79 | House79 | Road79 | Town79 | County79 | PC79 | [NAME] | [NAME] | EM079
80 | Test80 | User80 | Company80 | House80 | Road80 | Town80 | County80 | PC80 | TN080 | [NAME] | [NAME]
81 | Test81 | User81 | Company81 | House81 | Road81 | Town81 | County81 | PC81 | TN081 | [NAME] | EM081
82 | Test82 | User82 | Company82 | House82 | Road82 | Town82 | County82 | PC82 | TN082 | MN082 | EM082
83 | Test83 | User83 | Company83 | House83 | Road83 | Town83 | County83 | PC83 | TN083 | MN083 | EM083
84 | Test84 | User84 | Company84 | House84 | Road84 | Town84 | County84 | PC84 | TN084 | MN084 | EM084
85 | Test85 | User85 | [NAME] | House85 | Road85 | Town85 | County85 | PC85 | TN085 | MN085 | EM085
86 | Test86 | User86 | Company86 | House86 | [NAME] | Town86 | County86 | PC86 | TN086 | MN086 | EM086
87 | Test87 | User87 | Company87 | House87 | Road87 | Town87 | County87 | PC87 | TN087 | MN087 | EM087
88
89
90
91
92
93
94
95
96
97
98
99
100