Spreadsheet: 795158d1662548292-do-vlookup-if-column-c-has-data-daybook-check-prices
Sheet: Sheet1

Date | Particulars |  |  | VLOOKUP | VAR | Vch Type | Vch No. | Debit | Credit
 |  |  |  |  |  |  |  | Amount | Amount
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 1 | 30000
 | SALES |  |  |  |  |  |  |  | 30000
 | MAJI MASAFI 12LTR | 10 | 3000 |  |  | 30000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 2 | 24000
 | SALES |  |  |  |  |  |  |  | 24000
 | MO LUXURY SOAP 20G - 1 X 200 | 1 | 24000 |  |  | 24000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 3 | 106000
 | SALES |  |  |  |  |  |  |  | 106000
 | SUGAR KILOMBERO - 1 X 20 | 2 | 53000 |  |  | 106000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 4 | 31000
 | SALES |  |  |  |  |  |  |  | 31000
 | MO POA LEMON 15KG | 1 | 31000 |  |  | 31000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 5 | 6000
 | SALES |  |  |  |  |  |  |  | 6000
 | MAJI MASAFI 17LTR | 1 | 6000 |  |  | 6000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 6 | 48500
 | SALES |  |  |  |  |  |  |  | 48500
 | SAFI OIL 10 LTR BUCKET | 1 | 48500 |  |  | 48500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 7 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 8 | 14500
 | SALES |  |  |  |  |  |  |  | 14500
 | MO POA LITE LAUNDRY BAR SOAP 475G - 1 X 10 | 1 | 14500 |  |  | 14500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 9 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 10 | 194000
 | SALES |  |  |  |  |  |  |  | 194000
 | SAFI OIL 10 LTR BUCKET | 4 | 48500 |  |  | 194000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 11 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 12 | 137500
 | SALES |  |  |  |  |  |  |  | 137500
 | MO HALISI 15KG | 5 | 27500 |  |  | 137500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 13 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 14 | 258000
 | SALES |  |  |  |  |  |  |  | 258000
 | WHEAT FLOUR SAFI HBF 25KG | 6 | 43000 |  |  | 258000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 15 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 16 | 159000
 | SALES |  |  |  |  |  |  |  | 159000
 | SUGAR KILOMBERO - 1 X 20 | 3 | 53000 |  |  | 159000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 17 | 5200
 | SALES |  |  |  |  |  |  |  | 5200
 | MO EXTRA SODA 400ML - 1 X 12 | 1 | 5200 |  |  | 5200
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 18 | 62500
 | SALES |  |  |  |  |  |  |  | 62500
 | SUGAR 25KG | 1 | 62500 |  |  | 62500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 19 | 17500
 | SALES |  |  |  |  |  |  |  | 17500
 | MO PROTECTOR DETERGENT POWDER 200G - 1 X 40 | 1 | 17500 |  |  | 17500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 20 | 21000
 | SALES |  |  |  |  |  |  |  | 21000
 | MAJI MASAFI 350 ML - 1 X 24 | 5 | 4200 |  |  | 21000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 21 | 449000
 | SALES |  |  |  |  |  |  |  | 449000
 | MO HANDWASH 500 ML - 1 X 12 | 2 | 20000 |  |  | 40000
 | MO DISH WASH 750 ML - 1 X 12 | 2 | 24500 |  |  | 49000
 | MO 29 MULTI PURPOSE SOAP 125 G - 1 X 100 | 1 | 42500 |  |  | 42500
 | MO SPAGHETTI = 1 X 21 | 1 | 26500 |  |  | 26500
 | IMPERIAL SOAP 200G | 1 | 123000 |  |  | 123000
 | BISCUITS ROYAL FLAVOUR | 1 | 40000 |  |  | 40000
 | IVORY MILK | 1 | 63000 |  |  | 63000
 | SAFI OIL 900 ML - 1 X 12 | 1 | 65000 |  |  | 65000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 22 | 5200
 | SALES |  |  |  |  |  |  |  | 5200
 | MO EXTRA SODA 400ML - 1 X 12 | 1 | 5200 |  |  | 5200
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 23 | 11500
 | SALES |  |  |  |  |  |  |  | 11500
 | POA DETERGENT 50 G - 1 X 72 | 1 | 11500 |  |  | 11500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 24 | 34500
 | SALES |  |  |  |  |  |  |  | 34500
 | MO BEAUTY SOAP PINK 72G - 1 X 80 | 1 | 34500 |  |  | 34500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 25 | 327000
 | SALES |  |  |  |  |  |  |  | 327000
 | MO MPISHI 10KG COOKING FAT | 6 | 54500 |  |  | 327000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 26 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 27 | 129000
 | SALES |  |  |  |  |  |  |  | 129000
 | WHEAT FLOUR SAFI HBF 25KG | 3 | 43000 |  |  | 129000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 28 | 53000
 | SALES |  |  |  |  |  |  |  | 53000
 | SUGAR KILOMBERO - 1 X 20 | 1 | 53000 |  |  | 53000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 29 | 1370000
 | SALES |  |  |  |  |  |  |  | 1370000
 | MO HALISI 350G - 1 X 30 | 20 | 22000 |  |  | 440000
 | MO POA LEMON 15KG | 30 | 31000 |  |  | 930000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 30 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 31 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 32 | 130500
 | SALES |  |  |  |  |  |  |  | 130500
 | SISAL SMALL  - 1 X 10 | 1 | 35000 |  |  | 35000
 | MO HALISI 15KG | 2 | 27500 |  |  | 55000
 | AFRICA MSHUMA | 1 | 40500 |  |  | 40500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 33 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 34 | 53000
 | SALES |  |  |  |  |  |  |  | 53000
 | SUGAR KILOMBERO - 1 X 20 | 1 | 53000 |  |  | 53000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 35 | 5000
 | SALES |  |  |  |  |  |  |  | 5000
 | MAJI MAISHA 600ML - 1 X 12 | 2 | 2500 |  |  | 5000
2022-09-06 00:00:00 | (cancelled) |  |  |  |  | Sales | 36
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 37 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 38 | 53000
 | SALES |  |  |  |  |  |  |  | 53000
 | SUGAR KILOMBERO - 1 X 20 | 1 | 53000 |  |  | 53000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 39 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 40 | 6000
 | SALES |  |  |  |  |  |  |  | 6000
 | MAJI MASAFI 17LTR | 1 | 6000 |  |  | 6000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 41 | 58000
 | SALES |  |  |  |  |  |  |  | 58000
 | DAFTARI MSOMI | 1 | 58000 |  |  | 58000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 42 | 3000
 | SALES |  |  |  |  |  |  |  | 3000
 | MAJI MASAFI 12LTR | 1 | 3000 |  |  | 3000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 43 | 247500
 | SALES |  |  |  |  |  |  |  | 247500
 | MO HALISI 15KG | 9 | 27500 |  |  | 247500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 44 | 700000
 | SALES |  |  |  |  |  |  |  | 700000
 | SISAL SMALL  - 1 X 10 | 20 | 35000 |  |  | 700000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 45 | 530000
 | SALES |  |  |  |  |  |  |  | 530000
 | SUGAR KILOMBERO - 1 X 20 | 10 | 53000 |  |  | 530000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 46 | 31000
 | SALES |  |  |  |  |  |  |  | 31000
 | MO POA LEMON 15KG | 1 | 31000 |  |  | 31000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 47 | 54500
 | SALES |  |  |  |  |  |  |  | 54500
 | MO MPISHI 10KG COOKING FAT | 1 | 54500 |  |  | 54500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 48 | 52000
 | SALES |  |  |  |  |  |  |  | 52000
 | MO EXTRA SODA 400ML - 1 X 12 | 10 | 5200 |  |  | 52000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 49 | 27500
 | SALES |  |  |  |  |  |  |  | 27500
 | MO HALISI 15KG | 1 | 27500 |  |  | 27500
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 50 | 25000
 | SALES |  |  |  |  |  |  |  | 25000
 | MAJI MAISHA 600ML - 1 X 12 | 10 | 2500 |  |  | 25000
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 51 | 8400
 | SALES |  |  |  |  |  |  |  | 8400
 | MAJI MASAFI 350 ML - 1 X 24 | 2 | 4200 |  |  | 8400
2022-09-06 00:00:00 | 1.CASH |  |  |  |  | Sales | 52 | 4500
 | SALES |  |  |  |  |  |  |  | 4500
 | MAJI MASAFI 350 ML - 1 X 24 | 1 | 4500 |  |  | 4500