Spreadsheet: 215446d1361381340-substraction-with-vlookup-with-intermingled-data-prt1-edit-on-column-i-
Sheet: Sheet1

DATE | [NAME] | OP/IPD | NAME | MEDICINE | SALE | UN/PAID | COST | STOCK | BASE STOCK |  | AMOUNT |  |  |  |  |  |  |  |  |  |  |  | stock
 |  |  |  | powercef 1.5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWERCEF 1.5 | 105
 |  |  |  | xone xp 250mg | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIFTAZ 750Mg | 73 | 20
 |  |  |  | amikamac 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XONE XP 500Mg | 80 | 20
 |  |  |  | xone xp 250mg | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XONE XP 250Mg | 47 | 40
 |  |  |  | powercef 1.5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 1Gm | 69 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XONE 500Mg | 46 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XONE 250Mg | 23 | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAXIMAX 1.5Mg | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAXIMAX 750Mg | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAXIM 1Gm | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAXIM 500Mg | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMPOXIN 1Gm | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMPOXIN 500Gm | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMPOXIN 250Mg | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIPZO 2.25 Gm | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIPZO 1.125 Gm | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3Cef [NAME] | 128
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3Cef [NAME] 750 Mg | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3Cef [NAME] 375 Mg | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIMACORT 200Mg | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIMACORT 100Mg | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMBITHER AT | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PANTIN IV | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERISET | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACILOC | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VOVERAN | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROTIN | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPASMO -PROXYWAN | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LASIX | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAL. GULUCONATE | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVIL | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEXAMETHASONE | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRINIL | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VITAMIN K | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMIKAMAC 500 | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMIKAMAC 250 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMIKAMAC 100 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NETILMAC 50 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NETILMAC 25 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NETILMAC 10 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRANDEM | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATCH 2CC | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATCH 1CC | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stemin 2ml | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MVI | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ELDERVIT-12 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUDATE | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV ISOP | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV ISOM | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV D5% | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV D10% | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV METRO | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV CIPRO | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV ORNAMAC | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV OFLOX | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV SET | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV PEDIYA SET | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTRCATH 26No. | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTRCATH 24No. BD | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTRACATH 24 No N | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTRACATH 22 No. | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTRACATH 18 No. | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCALP  VEIN 20 NO. | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MICRO PORE | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GLOVES | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COTTON BUNDLE | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IV DEXTROSE 50 % | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEEDING TUBE | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INJ TIDILAN | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYRINGES | 5