Spreadsheet: 864888d1712034417-populating-rows-with-values-based-on-another-column-invoices-matching-with-receipts-muhammadziaurrehman-
Sheet: Sheet3

 |  |  | Month |  | July 2012 | August 2012 | September 2012 | October 2012 | November 2012 | December 2012 | January 2013 | February 2013 | March 2013 | April 2013 | May 2013 | June 2013 | July 2013
 |  |  |  |  | 2012-09-05 00:00:00 | 2012-10-05 00:00:00 | 2012-11-05 00:00:00 | 2012-12-05 00:00:00 | 2013-01-05 00:00:00 | 2012-02-05 00:00:00 | 2012-03-05 00:00:00 | 2012-04-05 00:00:00 | 2012-05-05 00:00:00 | 2012-06-05 00:00:00 | 2012-07-05 00:00:00 | 2012-08-05 00:00:00 | 2012-09-05 00:00:00
Receipt Date | Receipt Amounts |  | [NAME] |  | 1484350358 | 1240262101.8592 | 287436072.6944 | 846407772.448 | 1353378555.6704 | 1676707347.4368 | 1663380737.410278 | 1392112089.562431 | 1269977777.626544 | 667396529.4843956 | 1037644918.587293 | 717773873.04083 | 1017001005.273081
2013-06-28 00:00:00 | 590922102
2013-06-28 00:00:00 | 62457827
2013-06-28 00:00:00 | 627193908.1020801
2013-06-28 00:00:00
2013-06-28 00:00:00 | 632313796.3537601
2013-06-28 00:00:00
2013-06-28 00:00:00 | 619941969.64092
2013-06-28 00:00:00
2013-06-28 00:00:00 | 660865457.3188
2013-06-28 00:00:00
2013-06-28 00:00:00 | 799995982
2013-06-28 00:00:00
2013-06-28 00:00:00 | 728097017
2013-06-28 00:00:00
2013-06-28 00:00:00 | 755658096.7957598
2013-06-28 00:00:00
2013-06-28 00:00:00 | 733026521.9152801
2013-06-28 00:00:00
2013-06-28 00:00:00 | 744249154.92984
2013-06-28 00:00:00 | 592872499.6044
2013-06-28 00:00:00 | 539128116
2013-06-28 00:00:00 | 450473276.3433799
2013-06-28 00:00:00 | 104399117.90566
2013-06-28 00:00:00 | 307422182.6222
2013-06-28 00:00:00 | 491558091.7870601
2013-06-28 00:00:00 | 608993736.9985198
2013-06-28 00:00:00 | 570256457.2315292
2013-06-28 00:00:00 | 41000000
2013-06-28 00:00:00 | 11057712.02234915
2013-06-28 00:00:00 | 393921092.082
2013-06-28 00:00:00 | 18611910.8
2013-06-28 00:00:00 | 175169348.638144
2013-06-28 00:00:00 | 249413390.28555
2013-06-28 00:00:00 | 11784237.67
2013-06-28 00:00:00 | 92054693.72198561
2013-07-01 00:00:00 | 79594963.76847076
2013-07-02 00:00:00 | 3405036.231529236
2013-07-03 00:00:00 | 33000000
2013-07-05 00:00:00 | 108000000
2013-07-08 00:00:00 | 135000000
2013-07-10 00:00:00 | 25000000
2013-07-10 00:00:00 | 15000000
2013-07-16 00:00:00 | 46000000
2013-07-18 00:00:00 | 26000000
2013-07-22 00:00:00 | 50000000
2013-07-24 00:00:00 | 50000000
2013-07-25 00:00:00 | 13000000
2013-07-30 00:00:00 | 157554839.9634768
2013-07-30 00:00:00 | 27779267.08335006
2013-07-30 00:00:00 | 18321722.99
2013-07-30 00:00:00 | 143123437.0465232
2013-07-31 00:00:00 | 214000000
2013-08-01 00:00:00 | 27912009.57697403
2013-08-01 00:00:00 | 186087990.423026
2013-08-05 00:00:00 | 215000000
2013-08-07 00:00:00 | 43000000
2013-08-07 00:00:00 | 64000000
2013-08-15 00:00:00 | 22000000
2013-08-20 00:00:00 | 19000000
2013-08-20 00:00:00 | 21000000
2013-08-20 00:00:00 | 39000000
2013-08-22 00:00:00 | 58720403.18465
2013-08-22 00:00:00 | 12601956.21
2013-08-22 00:00:00 | 44677640.60535
2013-08-27 00:00:00 | 10169075.60535
2013-08-27 00:00:00 | 57830924.39465
2013-08-28 00:00:00 | 78000000
2013-08-28 00:00:00 | 6899252.07802403
2013-08-28 00:00:00 | 12100747.92197597
2013-08-29 00:00:00 | 165000000
2013-09-02 00:00:00 | 137043459.8848841
2013-09-02 00:00:00 | 87956540.11511594
2013-09-04 00:00:00 | 158000000
2013-09-04 00:00:00 | 93000000
2013-09-05 00:00:00 | 93000000
2013-09-09 00:00:00 | 93000000
2013-09-11 00:00:00 | 56000000
2013-09-16 00:00:00 | 28000000
2013-09-17 00:00:00 | 88000000
2013-09-20 00:00:00 | 36000000
2013-09-20 00:00:00 | 36000000
2013-09-24 00:00:00 | 47614031.69
2013-09-24 00:00:00 | 17803732.43
2013-09-24 00:00:00 | 6582235.880000003
2013-09-25 00:00:00 | 69000000
2013-09-26 00:00:00 | 56463951.35230404
2013-09-26 00:00:00 | 335942948.64618
2013-09-26 00:00:00 | 72187140.95308131
2013-09-26 00:00:00 | 16405959.04843462
2013-09-27 00:00:00 | 144000000
2013-09-30 00:00:00 | 107000000
2013-10-02 00:00:00 | 125000000
2013-10-02 00:00:00 | 74407905.27156538
2013-10-02 00:00:00 | 104592094.7284346
2013-10-03 00:00:00 | 179000000
2013-10-04 00:00:00 | 122665113.5681654
2013-10-04 00:00:00 | 18805592.2
2013-10-04 00:00:00 | 1529294.231834635
2013-10-07 00:00:00 | 71000000
2013-10-08 00:00:00 | 36000000
2013-10-10 00:00:00 | 41000000
2013-10-21 00:00:00 | 6555428.524867356
2013-10-21 00:00:00 | 13444571.47513264
2013-10-21 00:00:00 | 33000000
2013-10-23 00:00:00 | 33000000
2013-10-23 00:00:00 | 33000000
2013-10-24 00:00:00 | 31000000
2013-10-25 00:00:00 | 133000000
2013-10-25 00:00:00 | 65000000
2013-10-28 00:00:00 | 70000000
2013-10-29 00:00:00 | 81638056.00886738
2013-10-29 00:00:00 | 52361943.99113262
2013-10-30 00:00:00 | 134000000
2013-10-31 00:00:00 | 101000000
2013-11-03 00:00:00 | 67000000
2013-11-05 00:00:00 | 17331308.7667374
2013-11-05 00:00:00 | 17205631.29
2013-11-05 00:00:00 | 32463059.9432626
2013-11-05 00:00:00 | 67000000
2013-11-06 00:00:00 | 43342131.25692129
2013-11-06 00:00:00 | 6657868.743078709
2013-11-11 00:00:00 | 58000000
2013-11-11 00:00:00 | 25000000
2013-11-12 00:00:00 | 33000000
2013-11-13 00:00:00 | 33000000
2013-11-19 00:00:00 | 17000000
2013-11-20 00:00:00 | 17000000
2013-11-21 00:00:00 | 17000000
2013-11-22 00:00:00 | 25000000
2013-11-25 00:00:00 | 50000000
2013-11-26 00:00:00 | 67000000
2013-11-27 00:00:00 | 100000000
2013-11-28 00:00:00 | 2473783.680721283
2013-11-28 00:00:00 | 179526216.3192787
2013-11-29 00:00:00 | 196000000
2013-12-01 00:00:00 | 105000000
2013-12-03 00:00:00 | 72492345.99606133
2013-12-03 00:00:00 | 25599155.78
2013-12-03 00:00:00 | 7908498.223938674
2013-12-04 00:00:00 | 53000000
2013-12-05 00:00:00 | 80000000
2013-12-06 00:00:00 | 61000000
2013-12-09 00:00:00 | 10562190.82604119
2013-12-09 00:00:00 | 68437809.17395881
2013-12-09 00:00:00 | 50000000
2013-12-10 00:00:00 | 20000000
2013-12-11 00:00:00 | 20000000
2013-12-12 00:00:00 | 20000000
2013-12-16 00:00:00 | 44000000
2013-12-18 00:00:00 | 32000000
2013-12-19 00:00:00 | 9000000
2013-12-20 00:00:00 | 15000000
2013-12-24 00:00:00 | 38000000
2013-12-26 00:00:00 | 78000000
2013-12-27 00:00:00 | 78000000
2013-12-30 00:00:00 | 157000000
2014-01-01 00:00:00 | 41772055.37764144
2014-01-01 00:00:00 | 95227944.62235856
2014-01-01 00:00:00 | 137000000
2014-01-03 00:00:00 | 156000000
2014-01-06 00:00:00 | 59000000
2014-01-07 00:00:00 | 69863322.09976143
2014-01-07 00:00:00 | 8136677.900238574
2014-01-08 00:00:00 | 15799408.13976143
2014-01-08 00:00:00 | 11200591.86023857
2014-01-09 00:00:00 | 11000000
2014-01-20 00:00:00 | 27000000
2014-01-22 00:00:00 | 18000000
2014-01-23 00:00:00 | 27000000
2014-01-24 00:00:00 | 37000000
2014-01-27 00:00:00 | 37000000
2014-01-28 00:00:00 | 30466768.02401778
2014-01-28 00:00:00 | 6533231.975982219
2014-01-29 00:00:00 | 73000000
2014-01-30 00:00:00 | 92000000
2014-01-31 00:00:00 | 54000000
2014-02-03 00:00:00 | 73000000
2014-02-04 00:00:00 | 54000000
2014-02-06 00:00:00 | 37000000
2014-02-10 00:00:00 | 63000000
2014-02-13 00:00:00 | 14000000
2014-02-17 00:00:00 | 7000000
2014-02-19 00:00:00 | 12000000
2014-02-20 00:00:00 | 23000000
2014-02-21 00:00:00 | 13000000
2014-02-26 00:00:00 | 23000000
2014-02-26 00:00:00 | 48000000
2014-02-27 00:00:00 | 48000000
2014-02-28 00:00:00 | 95000000
2014-03-03 00:00:00 | 151453348.09144
2014-03-03 00:00:00 | 24739774.48
2014-03-03 00:00:00 | 111806877.42856
2014-03-04 00:00:00 | 72000000
2014-03-05 00:00:00 | 14468975.82426324
2014-03-05 00:00:00 | 21531024.17573676
2014-03-06 00:00:00 | 48000000
2014-03-07 00:00:00 | 36000000
2014-03-10 00:00:00 | 14000000
2014-03-12 00:00:00 | 14000000
2014-03-13 00:00:00 | 12000000
2014-03-19 00:00:00 | 12000000
2014-03-21 00:00:00 | 24000000
2014-03-26 00:00:00 | 86000000
2014-03-27 00:00:00 | 98000000
2014-03-28 00:00:00 | 123000000
2014-03-31 00:00:00 | 12000000
2014-04-01 00:00:00 | 31697053.42000002
2014-04-01 00:00:00 | 22393100.65
2014-04-01 00:00:00 | 68909845.92999998
2014-04-02 00:00:00 | 90980854.80905846
2014-04-02 00:00:00 | 155019145.1909415
2014-04-03 00:00:00 | 169621113.359496
2014-04-03 00:00:00 | 52378886.640504
2014-04-04 00:00:00 | 246000000
2014-04-07 00:00:00 | 116000000
2014-04-22 00:00:00 | 50000000
2014-04-23 00:00:00 | 26000000
2014-04-24 00:00:00 | 51000000
2014-04-25 00:00:00 | 128000000
2014-04-29 00:00:00 | 117654807.66
2014-04-29 00:00:00 | 21426589.83
2014-04-29 00:00:00 | 116918602.51
2014-04-30 00:00:00 | 74528644
2014-04-30 00:00:00
2014-04-30 00:00:00 | 29777808
2014-04-30 00:00:00
2014-04-30 00:00:00 | 49693548
2014-05-05 00:00:00 | 41614622
2014-05-05 00:00:00
2014-05-05 00:00:00 | 61385378
2014-05-05 00:00:00
2014-05-05 00:00:00 | 12709511
2014-05-05 00:00:00
2014-05-05 00:00:00 | 71875785
2014-05-05 00:00:00
2014-05-05 00:00:00 | 43414704
2014-05-06 00:00:00 | 29561499
2014-05-06 00:00:00 | 34438501
2014-05-07 00:00:00 | 47651819.39691532
2014-05-07 00:00:00 | 42348180.60308468
2014-05-08 00:00:00 | 51000000
2014-05-14 00:00:00 | 13000000
2014-05-15 00:00:00 | 13000000
2014-05-21 00:00:00 | 90000000
2014-05-26 00:00:00 | 103000000
2014-05-27 00:00:00 | 106000000
2014-05-28 00:00:00 | 56603511.96569532
2014-05-28 00:00:00 | 20825734.13
2014-05-28 00:00:00 | 55570753.90430468
2014-06-02 00:00:00 | 23694697
2014-06-02 00:00:00 | 228502210
2014-06-02 00:00:00 | 132803093
2014-06-03 00:00:00 | 58123954.69999999
2014-06-03 00:00:00 | 44248163.90000001
2014-06-03 00:00:00 | 109627881.4
2014-06-04 00:00:00 | 20668881.59999998
2014-06-04 00:00:00 | 130331118.4
2014-06-05 00:00:00 | 38967106
2014-06-05 00:00:00 | 112032894
2014-06-06 00:00:00 | 25000000
2014-06-20 00:00:00 | 39042070.49999999
2014-06-20 00:00:00 | 258113815.8
2014-06-20 00:00:00 | 167844113.7
2014-06-21 00:00:00 | 75929395.1
2014-06-21 00:00:00 | 44070604.90000001
2014-06-24 00:00:00 | 60000000
2014-06-25 00:00:00 | 34144664
2014-06-25 00:00:00 | 15651819.07962361
2014-06-25 00:00:00 | 132424249.8403764
2014-06-26 00:00:00 | 180000000
2014-06-27 00:00:00 | 120000000
2014-07-02 00:00:00 | 65802994.09999999
2014-07-02 00:00:00 | 54197005.90000001
2014-07-02 00:00:00 | 131922102.1
2014-07-02 00:00:00 | 350298000.179496
2014-07-02 00:00:00 | 118779897.7205039
2014-07-03 00:00:00 | 28240728.25182366
2014-07-03 00:00:00 | 20199288.44
2014-07-03 00:00:00 | 201991069.064017
2014-07-03 00:00:00 | 344286577.58
2014-07-03 00:00:00 | 6282336.664159298
2014-07-04 00:00:00 | 8813979.155840702
2014-07-04 00:00:00 | 81186020.8441593
2014-07-07 00:00:00 | 155224221.3125831
2014-07-07 00:00:00 | 69775778.68741691
2014-07-16 00:00:00 | 108000000
2014-07-23 00:00:00 | 43000000
2014-07-23 00:00:00 | 22000000
2014-08-04 00:00:00 | 129000000
2014-08-05 00:00:00 | 65000000
2014-08-05 00:00:00 | 63000000
2014-08-06 00:00:00 | 128000000
2014-08-07 00:00:00 | 128000000
2014-08-08 00:00:00 | 73000000
2014-08-11 00:00:00 | 64331015.38999999
2014-08-11 00:00:00 | 19668984.61000001
2014-08-12 00:00:00 | 34000000
2014-08-15 00:00:00 | 34000000
2014-08-18 00:00:00 | 110204079.926913
2014-08-18 00:00:00 | 57795920.07308698
2014-08-19 00:00:00 | 25000000
2014-08-21 00:00:00 | 85000000
2014-08-25 00:00:00 | 66000000
2014-08-28 00:00:00 | 25217865
2014-08-28 00:00:00 | 3190395.139999986
2014-08-28 00:00:00 | 70591739.86000001
2014-09-02 00:00:00 | 128000000
2014-09-02 00:00:00 | 98000000
2014-09-05 00:00:00 | 35000000
2014-09-05 00:00:00 | 63000000
2014-09-05 00:00:00 | 95000000.29582247
2014-09-05 00:00:00 | 2999999.704177529
2014-09-08 00:00:00 | 16015212.22691303
2014-09-08 00:00:00 | 81984787.77308697
2014-09-11 00:00:00 | 33000000
2014-09-12 00:00:00 | 16000000
2014-09-16 00:00:00 | 16000000
2014-09-17 00:00:00 | 16000000
2014-09-24 00:00:00 | 84000000
2014-09-25 00:00:00 | 84000000
2014-09-28 00:00:00 | 99000000
2014-09-28 00:00:00 | 30000000
2014-09-28 00:00:00 | 157009651.8507825
2014-09-28 00:00:00 | 5990348.149217486
2014-09-28 00:00:00 | 19204447.09078252
2014-09-28 00:00:00 | 57795552.90921748
2014-09-29 00:00:00 | 84000000
2014-10-13 00:00:00 | 23000000
2014-10-13 00:00:00 | 87150131.95921093
2014-10-13 00:00:00 | 20849868.04078907
2014-10-13 00:00:00 | 46000000
2014-10-13 00:00:00 | 123000000
2014-10-15 00:00:00 | 74000000
2014-10-20 00:00:00 | 45000000
2014-10-20 00:00:00 | 174000000
2014-10-21 00:00:00 | 25000000
2014-10-22 00:00:00 | 24366756.95921093
2014-10-22 00:00:00 | 24923509
2014-10-22 00:00:00 | 709734.0407890677
2014-10-22 00:00:00 | 15000000
2014-10-23 00:00:00 | 50000000
2014-10-27 00:00:00 | 50000000
2014-10-27 00:00:00 | 50000000
2014-10-28 00:00:00 | 41153152.95921093
2014-10-28 00:00:00 | 68846847.04078907
2014-10-29 00:00:00 | 98000000
2014-10-29 00:00:00 | 165000000
2014-10-30 00:00:00 | 75000000
2014-11-05 00:00:00 | 269000000
2014-11-06 00:00:00 | 147000000
2014-11-10 00:00:00 | 23143939.52397996
2014-11-10 00:00:00 | 20564949.87
2014-11-10 00:00:00 | 103291110.60602
2014-11-11 00:00:00 | 24000000
2014-11-17 00:00:00 | 88643462.75150833
2014-11-17 00:00:00 | 97000000
2014-11-17 00:00:00 | 122000000
2014-11-17 00:00:00 | 49000000
2014-11-17 00:00:00 | 78356537.24849167
2014-11-19 00:00:00 | 59000000
2014-11-20 00:00:00 | 35000000
2014-11-24 00:00:00 | 90000000
2014-11-25 00:00:00 | 75000000
2014-11-26 00:00:00 | 50000000
2014-11-27 00:00:00 | 129077570.2077026
2014-11-27 00:00:00 | 20922429.79229736
2014-11-28 00:00:00 | 221000000
2014-12-02 00:00:00 | 201000000
2014-12-03 00:00:00 | 74104468.3339026
2014-12-03 00:00:00 | 24212180.3
2014-12-03 00:00:00 | 151683351.3660974
2014-12-08 00:00:00 | 12000000
2014-12-11 00:00:00 | 36000000
2014-12-11 00:00:00 | 38000000
2014-12-22 00:00:00 | 55563727.46232444
2014-12-22 00:00:00 | 51000000
2014-12-22 00:00:00 | 4436272.53767556
2014-12-23 00:00:00 | 28000000
2014-12-31 00:00:00 | 29931006.84999999
2014-12-31 00:00:00 | 214265898.3
2014-12-31 00:00:00 | 56000000
2014-12-31 00:00:00 | 248448874.7845886
2014-12-31 00:00:00 | 123331780.85
2014-12-31 00:00:00 | 84925560.44999996
2014-12-31 00:00:00 | 505325605.4078999
2014-12-31 00:00:00 | 201992887
2014-12-31 00:00:00 | 48150155.34
2014-12-31 00:00:00 | 150963158.2
2014-12-31 00:00:00 | 793329458
2014-12-31 00:00:00 | 452242620.8
2014-12-31 00:00:00 | 21178356.28
2014-12-31 00:00:00 | 124785637.7400001
2015-01-14 00:00:00 | 68000000
2015-01-27 00:00:00 | 329514377.5289401
2015-01-27 00:00:00 | 469891824.9710599
2015-01-27 00:00:00 | 49000000