Spreadsheet: 136695d1326794945-index-match-formula-index-and-match-formula
Sheet: Budget

 |  |  | Sales by Customer |  |  | $BF$43 | $BV$43 | $[NAME] | $BX$43 | $[NAME] | $BZ$43 | $CA$43 | $CB$43 | $[NAME] | $CD$43 | $CE$43 | $[NAME] | $[NAME] |  | $BH$43 | $[NAME] | $[NAME] | $[NAME] | $BL$43 | $BM$43 | $BN$43 | $[NAME] | $BP$43 | $BQ$43 | $[NAME] | $[NAME] |  | $AJ$43 | $[NAME] | $AL$43 | $AM$43 | $[NAME] | $AO$43 | $AP$43 | $AQ$43 | $AR$43 | $[NAME] | $AT$43 | $AU$43
 |  |  |  |  |  |  | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales | Unit Sales
 | [NAME] | Customer Reference | Customer Name | ES Rate | Units Per day | Unit Volume per day | April | May | June | July | August | September | October | November | December | January | February | March | April - March Units | April | May | June | July | August | September | October | November | December | January | February | March | April - March M2 | April | May | June | July | August | September | October | November | December | January | February | March | April - March £000s
 |  |  |  | NONE/HALF/FULL | No of Units | m2 | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | m2 | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s | £000s
 | 1 | 1 | Customer 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 2 | Customer 2 |  | 180 | 99.53164266988348 | 3420 | 3960 | 3420 | 3960 | 3960 | 3821.538461538461 | 4553.999999999999 | 4395.6 | 2271.176470588235 | 2906.999999999999 | 3255.882352941177 | 3599.999999999999 | 43525.19728506787 | 1891.101210727786 | 2189.696138737437 | 1891.101210727786 | 2189.696138737437 | 2189.696138737437 | 2113.133336683681 | 2518.150559548053 | 2430.562713998555 | 1255.85513839353 | 1607.436029118619 | 1800.351771822893 | 1990.63285339767 | 24067.41324063089 | 54.41281207933216 | 63.00430872343725 | 54.41281207933216 | 63.00430872343725 | 63.00430872343725 | 60.8013608659744 | 72.45495503195286 | 69.93478268301534 | 36.13482412079489 | 46.25089026743233 | 51.80167094239828 | 57.27664429403386 | 692.493678534578
 | 3 | 3 | Customer 3 |  | 230 | 113.9735525206144 | 4369.999999999999 | 5059.999999999999 | 4369.999999999999 | 5059.999999999999 | 5059.999999999999 | 4883.076923076923 | 5819.000000000001 | 5616.6 | 2902.058823529412 | 3714.5 | 4160.294117647059 | 4600.000000000001 | 55615.52986425339 | 2165.497497891673 | 2507.418155453516 | 2165.497497891673 | 2507.418155453516 | 2507.418155453516 | 2419.746191976121 | 2883.530878771543 | 2783.234152553403 | 1438.0780597454 | 1840.672873207922 | 2061.580435299348 | 2279.471050412288 | 27559.56310410992 | 61.57703260652961 | 71.29972196545533 | 61.57703260652961 | 71.29972196545533 | 71.29972196545533 | 68.80672469393592 | 81.99468026027367 | 79.14269138165542 | 40.89248759783469 | 52.34047771555017 | 58.62209760528748 | 64.81792905950486 | 783.6703194234674
 | 4 | 4 | Customer 4 |  | 120 | 54.35101233695004 | 2280 | 2640 | 2280 | 2640 | 2640 | 2547.692307692308 | 3036 | 2930.400000000001 | 1514.117647058824 | 1938 | 2170.588235294118 | 2400 | 29016.79819004525 | 1032.669234402051 | 1195.722271412901 | 1032.669234402051 | 1195.722271412901 | 1195.722271412901 | 1153.913800384478 | 1375.080612124837 | 1327.25172126832 | 685.7818909573991 | 877.768849241743 | 983.1138996242432 | 1087.020246739001 | 13142.43630338282 | 35.50077182102397 | 41.10615684539617 | 35.50077182102397 | 41.10615684539617 | 41.10615684539617 | 39.66887863401868 | 47.27208037220559 | 45.62783409838976 | 23.5755899554478 | 30.17565604787037 | 33.79717441165594 | 37.3692334958147 | 451.8064611936393
 | 5 | 5 | Customer 5 |  | 200 | 104.1111387109312 | 3800 | 4400 | 3800 | 4400 | 4400 | 4246.153846153848 | 5060 | 4884.000000000001 | 2523.529411764706 | 3230.000000000001 | 3617.647058823529 | 4000 | 48361.33031674209 | 1978.111635507693 | 2290.445051640486 | 1978.111635507693 | 2290.445051640486 | 2290.445051640486 | 2210.359560324386 | 2634.011809386559 | 2542.39400732094 | 1313.63760314675 | 1681.394890181539 | 1883.186773741844 | 2082.222774218624 | 25174.76584425748 | 50.9816384228012 | 59.03137080534876 | 50.9816384228012 | 59.03137080534876 | 59.03137080534876 | 56.96733686110581 | 67.88607642615108 | 65.52482159393713 | 33.8562273736559 | 43.33439265938102 | 48.53515113006615 | 53.66488255031706 | 648.8262778562629
 | 6 | 6 | Customer 6 |  | 60 | 30.42026273189209 | 1140 | 1320 | 1140 | 1320 | 1320 | 1273.846153846154 | 1518 | 1465.2 | 757.0588235294118 | 969 | 1085.294117647059 | 1200 | 14508.39909502263 | 577.9849919059498 | 669.2457801016261 | 577.9849919059498 | 669.2457801016261 | 669.2457801016261 | 645.8455780001705 | 769.6326471168701 | 742.862815912805 | 383.8321385876973 | 491.2872431200573 | 550.2488700033422 | 608.405254637842 | 7355.821871495562 | 17.72502131389372 | 20.52370888977167 | 17.72502131389372 | 20.52370888977167 | 20.52370888977167 | 19.80609669082861 | 23.60226522323743 | 22.78131686764656 | 11.77095068678081 | 15.06626811680966 | 16.87443979573473 | 18.6579171725197 | 225.5804238506599
 | 7 | 7 | Customer 7 |  | 150 | 77.2997844782853 | 2850 | 3300 | 2850 | 3300 | 3300 | 3184.615384615384 | 3795 | 3663 | 1892.64705882353 | 2422.5 | 2713.235294117647 | 3000 | 36270.99773755656 | 1468.695905087421 | 1700.595258522277 | 1468.695905087421 | 1700.595258522277 | 1700.595258522277 | 1641.133885846672 | 1955.684547300618 | 1887.660736959727 | 975.3413982701293 | 1248.391519324308 | 1398.216689827808 | 1545.995689565706 | 18691.60205283664 | 39.80181702854301 | 46.08631445410244 | 39.80181702854301 | 46.08631445410244 | 46.08631445410244 | 44.47490485780515 | 52.99926162221782 | 51.1558090440537 | 26.43185681926463 | 33.83154447426156 | 37.89182271293181 | 41.89664950372949 | 506.5444264536575
 | 8 | 8 | Customer 8 |  | 250 | 125.5278294841204 | 4749.999999999999 | 5500.000000000001 | 4749.999999999999 | 5500.000000000001 | 5500.000000000001 | 5307.692307692307 | 6325.000000000001 | 6105.000000000002 | 3154.411764705882 | 4037.5 | 4522.058823529412 | 5000 | 60451.6628959276 | 2385.028760198288 | 2761.612248650649 | 2385.028760198288 | 2761.612248650649 | 2761.612248650649 | 2665.052379816711 | 3175.854085948248 | 3065.389596002222 | 1583.865848490814 | 2027.274446168545 | 2270.576915668649 | 2510.556589682409 | 30353.46412812612 | 72.30462968579512 | 83.72115016249964 | 72.30462968579512 | 83.72115016249964 | 83.72115016249964 | 80.79383721975489 | 96.27932268687461 | 92.9304766803746 | 48.01654200496303 | 61.45893523292586 | 68.8349028742477 | 76.1101365113633 | 920.1968630695932
 | 9 | 9 | Customer 9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 10 | Customer 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0