Spreadsheet: 716602d1612280807-trying-to-use-conditional-formatting-to-color-cells-that-match-list-on-other-spreadsheet-using-named-ranges-in-conditional-formatting-tdarcy2188-
Sheet: Paste Invoice Here

CIN | SUB | NDC | UPC | ORIG QTY | ORDER QTY | SHIP QTY | OMIT | U/M | TRADE NAME | MFR | STRENGTH | FORM | SIZE | COST | TOTAL COST |  |  | Result
5560396 |  | 00641-6188-10 | 306416-188104 |  | 5 | 5 |  |  | ALBURX | HIKMAI | 10MG/ML | MDV | 10X5 ML | 90.82 | 454.1
4476982 |  | 54838-0117-40 | 354838-117400 |  | 4 | 4 |  |  | AVITENE | LANNET | 100MG/5ML | SYRP | 1X118 ML | 1.98 | 7.92
2226504 |  | 00338-0703-41 | 303380-703418 |  | 1 | 1 |  |  | POTASSIUM CHLORIDE | BAXTER | 20MEQ/50ML | IPSL | 24X50 ML | 78.11 | 78.11
4773404 |  | 39328-0064-12 | 339328-064129 |  | 2 | 2 |  |  | H-CHLOR 12 | PATRIN | 0.0013 | SOLN | 1X473 ML | 9.72 | 19.44
5316534 |  | 55150-0247-47 | 355150-247479 |  | 1 | 1 |  |  | LEVETIRACETAM | AUROME | 1000MG/100ML | IPSL | 10X100 ML | 162.76 | 162.76
5131818 |  | 00904-6510-61 | 309046-510611 |  | 1 | 1 |  |  | ARIPIPRAZOLE | MAJORP | 5MG | TABS | 10X10 EA | 588.67 | 588.67
1325901 |  | 00009-0758-01 | 300090-758011 |  | 4 | 4 |  |  | SOLU-MEDROL | PFIZER | 500MG | PWVL | 1X1 EA | 21.64 | 86.56
4282182 |  | 00009-0018-20 | 300090-018207 |  | 11 | 11 |  |  | ECONO ZIP BAGS | PFIZER | 1GM | PWVL | 1X1 EA | 47.7 | 524.7
5327556 |  | 70860-0100-10 | 203708-60100108 |  | 3 | 3 |  |  | AZITHROMYCIN | ATHENE | 500MG | PWVL | 10X1 EA | 28.79 | 86.37
4502886 |  | 52015-0080-01 | 352015-080011 |  | 1 | 1 |  |  | DIFICID | MERCKC | 200MG | TABS | 1X20 EA | 1 | 909.71 | 1 | 909.71
2996700 |  | 00517-2340-10 | 305172-340108 |  | 4 | 4 |  |  | VENOFER | AMERIC | 20MG/ML | SDPF | 10X5 ML | 301.75 | 1 | 207
1669829 |  | 51079-0736-20 | 351079-736209 |  | 1 | 1 |  |  | HALOPERIDOL | MYLANI | 5MG | TABS | 10X10 EA | 52.03 | 52.03
5551437 |  | 69367-0220-01 | 369367-220019 |  | 1 | 1 |  |  | SODIUM CHLORIDE | WESTMI | 1GM | TABS | 1X100 EA | 6.8 | 6.8
1065879 |  | 72140-0452-31 | 072140-452315 |  | 3 | 3 |  |  | AQUAPHOR HEALING | BEIERS |  | OINT | 1X50 GM | 4.67 | 14.01
5567250 |  | 50268-0562-15 | 350268-562155 |  | 4 | 4 |  |  | MIDODRINE HCL | AVKARE | 5MG | TABS | 5X10 EA | 21.39 | 85.56
5540802 |  | 44677-0102-02 | 044677-102025 |  | 20 | 20 |  |  | VIAL EMPTY | EMERSO |  | CRM | 1X7 GM | 2.54 | 50.8
4356226 |  | 16571-0401-10 | 316571-401109 |  | 1 | 1 |  |  | CETIRIZINE HCL | RISING | 5MG | TABS | 1X100 EA | 4.26 | 4.26
5042296 |  | 50268-0756-15 | 350268-756158 |  | 1 | 1 |  |  | TORSEMIDE | AVKARE | 20MG | TABS | 5X10 EA | 13.12 | 13.12
5572748 |  | 63323-0531-90 | 363323-531904 |  | 2 | 2 |  |  | ENOXAPARIN SODIUM | FRESEN | 80MG/0.8ML | SYRN | 10X0.8 ML | 67.3 | 134.6
4949053 |  | 67457-0423-12 | 367457-423128 |  | 2 | 2 |  |  | DEXAMETHASONE SODIUM PHOSPHATE | MYLANI | 4MG/ML | SDV | 25X1 ML | 11.11 | 22.22
5482583 |  | 60687-0356-01 | 360687-356013 |  | 1 | 1 |  |  | BENZTROPINE | AMERIC | 0.5MG | TABS | 10X10 EA | 32.59 | 32.59
4597233 |  | 00904-6290-61 | 309046-290612 |  | 1 | 1 |  |  | ATORVASTATIN CALCIUM | MAJORP | 10MG | TABS | 1X100 EA | 13.51 | 13.51
5240320 |  | 00904-6522-61 | 309046-522614 |  | 1 | 1 |  |  | SENNA-LAX | MAJORP | 8.6MG | TABS | 10X10 EA | 3.19 | 3.19
5424262 |  | 00904-6664-04 | 309046-664048 |  | 1 | 1 |  |  | ELLENCE | MAJORP | 10MG | TABS | 3X10 EA | 175.23 | 175.23
5043617 |  | 67457-0582-10 | 367457-582108 |  | 1 | 1 |  |  | FONDAPARINUX SODIUM | MYLANI | 2.5MG/0.5ML | SYRN | 10X0.5 ML | 91.61 | 91.61
5034517 |  | 00904-6292-61 | 309046-292616 |  | 1 | 1 |  |  | ATORVASTATIN CALCIUM | MAJORP | 40MG | TABS | 10X10 EA | 18.21 | 18.21
4806717 |  | 00003-0894-31 | 300030-894311 |  | 1 | 1 |  |  | ELIQUIS | BRISTO | 5MG | TABS | 10X10 EA | 137.16 | 137.16
5091319 |  | 00904-6442-61 | 309046-442615 |  | 1 | 1 |  |  | HYDRALAZINE HCL | MAJORP | 50MG | TABS | 10X10 EA | 9.17 | 9.17
3675287 |  | 00409-7332-01 | 304097-332014 |  | 4 | 4 |  |  | CEFTRIAXONE SODIUM | PFIZER | 1GM | PWVL | 10X1 EA | 11.8 | 47.2
2960896 |  | 63713-0019-63 | 207050-31003139 |  | 1 | 1 |  |  | SURGICEL FIBRILLAR 4X4N | ETHICO |  | PADA | 10X1 EA | 1 | 122.44 | 1 | 122.44
5466461 |  | 55150-0282-20 | 355150-282203 |  | 6 | 6 |  |  | ERTAPENEM SODIUM | AUROME | 1GM | PWVL | 10X1 EA | 500 | 3 | 0
5316526 |  | 55150-0246-47 | 355150-246572 |  | 2 | 2 |  |  | LEVETIRACETAM | AUROME | 500MG/100ML | IPSL | 10X100 ML | 102.05 | 204.1
5337779 |  | 55150-0208-30 | 355150-208302 |  | 5 | 5 |  |  | MEROPENEM | AUROME | 1GM | PWVL | 10X1 EA | 54.66 | 273.3
5645825 |  | 63323-0535-87 | 363323-535872 |  | 10 | 10 |  |  | ENOXAPARIN SODIUM | FRESEN | 40MG/0.4ML | SYRN | 10X0.4 ML | 33.74 | 337.4
5595558 |  | 63323-0540-15 | 203633-23540153 |  | 1 | 1 |  |  | HEPARIN SODIUM | FRESEN | 1000UNITS/ML | MDV | 25X10 ML | 55.09 | 55.09
3478880 |  | 00143-9924-90 | 301439-924906 |  | 1 | 1 |  |  | CEFAZOLIN SODIUM | HIKMAI | 1GM | PWVL | 25X1 EA | 16.23 | 16.23
1986280 |  | 00409-4887-10 | 203040-94887101 |  | 2 | 2 |  |  | WATER PLST FTV | PFIZER |  | SDV | 25X10 ML | 19.2 | 38.4
4282075 |  | 00009-0039-28 | 300090-039288 |  | 3 | 3 |  |  | SOLU-MEDROL | PFIZER | 40MG | PWVL | 25X1 EA | 110.19 | 330.57
5445721 |  | 00904-6666-61 | 309046-666615 |  | 2 | 2 |  |  | GABAPENTIN | MAJORP | 300MG | CAPS | 10X10 EA | 9.58 | 19.16
3453263 |  | 00517-7604-25 | 305177-604250 |  | 2 | 2 |  |  | ACETYLCYSTEINE | AMERIC | 200MG/ML | AMIH | 25X4 ML | 110.87 | 221.74
5028527 |  | 00904-6426-61 | 309046-426615 |  | 1 | 1 |  |  | ESCITALOPRAM | MAJORP | 10MG | TABS | 10X10 EA | 12.02 | 12.02
4604799 |  | 00904-6301-61 | 309046-301615 |  | 1 | 1 |  |  | CARVEDILOL | MAJORP | 6.25MG | TABS | 10X10 EA | 6.35 | 6.35
5509336 |  | 00904-6718-39 | 309046-718390 |  | 2 | 2 |  |  | MUCUS RELIEF | MAJORP | 600MG | TABS | 5X20 EA | 67.05 | 134.1
5525605 |  | 00904-6868-61 | 309046-868613 |  | 1 | 1 |  |  | TRAZODONE | MAJORP | 50MG | TABS | 10X10 EA | 8.13 | 8.13
1465277 |  | 17478-0284-35 | 317478-284352 |  | 1 | 1 |  |  | GENTAK | AKORNI | 0.003 | OINT | 1X3.5 GM | 25.92 | 25.92
4373122 |  | 63323-0495-27 | 363323-495275 |  | 1 | 1 |  |  | XYLOCAINE-MPF | FRESEN | 0.02 | SDPF | 25X2 ML | 43.21 | 43.21
1008127 |  | 00904-0530-61 | 009040-530614 |  | 1 | 1 |  |  | TAB-A-VITE | MAJORP |  | TABS | 10X10 EA | 2.51 | 2.51
4594693 |  | 00904-6294-61 | 309046-294610 |  | 1 | 1 |  |  | CLOPIDOGREL | MAJORP | 75MG | TABS | 10X10 EA | 12.86 | 12.86
4020350 |  | 60505-0829-01 | 360505-082919 |  | 8 | 8 |  |  | FLUTICASONE PROPIONATE | APOTEX | 50MCG | SPIN | 1X16 GM | 3.21 | 25.68
2365179 |  | 00409-6729-09 | 304096-729099 |  | 1 | 1 |  |  | MAGNESIUM SULFATE LF | PFIZER | 0.04 | IVSL | 12X1000 ML | 70.23 | 70.23
3441896 |  | 00641-0928-25 | 306410-928256 |  | 2 | 2 |  |  | PROMETHAZINE HCL | HIKMAI | 25MG/ML | SDV | 25X1 ML | 17.37 | 34.74
5097159 |  | 00904-6474-61 | 309046-474616 |  | 2 | 2 |  |  | PANTOPRAZOLE SODIUM | MAJORP | 40MG | TABS | 10X10 EA | 17.79 | 35.58
5100011 |  | 00173-0882-14 | 301730-882141 |  | 3 | 3 |  |  | BREO ELLIPTA INP | GLAXOS | 200-25MCG | ARIN | 1X28 EA | 53.35 | 160.05
4938551 |  | 00456-0600-10 | 304560-600107 |  | 1 | 1 |  |  | TEFLARO | ALLERG | 600MG | PWVL | 10X1 EA | 1 | 898.08 | 1 | 898.08
4604732 |  | 00904-6302-61 | 309046-302612 |  | 1 | 1 |  |  | CARVEDILOL | MAJORP | 12.5MG | TABS | 10X10 EA | 6.44 | 6.44
4896817 |  | 00173-0859-14 | 301730-859143 |  | 5 | 5 |  |  | BREO ELLIPTA INP | GLAXOS | 100-25MCG | ARIN | 1X28 EA | 53.35 | 266.75
3440435 |  | 00703-2914-03 | 307032-914030 |  | 2 | 2 |  |  | VECURONIUM BROMIDE | TEVAPH | 10MG | PWVL | 10X1 EA | 36.67 | 73.34
1454891 |  | 00409-6102-04 | 304096-102045 |  | 5 | 5 |  |  | FUROSEMIDE | PFIZER | 10MG/ML | SDPF | 25X4 ML | 16.46 | 82.3
5595541 |  | 63323-0262-06 | 203633-23262062 |  | 11 | 11 |  |  | HEPARIN SODIUM | FRESEN | 5000UNITS/ML | MDV | 25X1 ML | 26.06 | 286.66
5168513 |  | 00904-6455-61 | 309046-455615 |  | 3 | 3 |  |  | DOK | MAJORP | 100MG | GCAP | 10X10 EA | 2.48 | 7.44
2485464 |  | 51672-2003-06 | 351672-200367 |  | 1 | 1 |  |  | CLOTRIM VAGINAL | TAROPH | 0.01 | CRM | 1X45 GM | 3.47 | 3.47
1020700 |  | 00641-0376-25 | 306410-376255 |  | 2 | 2 |  |  | DIPHENHYDRAMINE HCL | HIKMAI | 50MG/ML | SDV | 25X1 ML | 13.22 | 26.44
4541074 |  | 00641-6078-25 | 306416-078257 |  | 9 | 9 |  |  | ONDANSETRON HCL | HIKMAI | 2MG/ML | SDPF | 25X2 ML | 10.09 | 90.81
5080536 |  | 68084-0875-01 | 368084-875014 |  | 1 | 1 |  |  | MONTELUKAST SODIUM | AMERIC | 10MG | TABS | 10X10 EA | 30.91 | 30.91
5168794 |  | 00603-1554-04 | 306031-554049 |  | 1 | 1 |  |  | POTASSIUM CHLORIDE | PARPHA | 20MEQ | PCKT | 1X100 EA | 685.03 | 685.03
1017839 |  | 25715-0401-93 | 025715-401935 | 3 | 2 | 2 | 2 |  | LABEL FEDERAL LAW PROHIBITS | APOTHE |  | LABL | 1X1000 EA | 5.41 | 10.82
SUMMARY
Total Pieces Shipped | 188
Amount | 15 | 694.91