Hello
I have 2 columns, i have been trying to find a way to match the values in one column with the next, the cells are a mess so no exact match is possible. I would like the results of possible matches to be displayed in the following columns Is in Pyxis and Is in Imprest.
So happy for a solution in vba or worksheet function.
below is the table
mighty thanks for your help
I have 2 columns, i have been trying to find a way to match the values in one column with the next, the cells are a mess so no exact match is possible. I would like the results of possible matches to be displayed in the following columns Is in Pyxis and Is in Imprest.
So happy for a solution in vba or worksheet function.
below is the table
mighty thanks for your help
Is in Pyxis? | Imprest | IS in Imprest Y/N | Pyxis |
formula here | Adenosine (Adenocor) Injection 6mg/2mL (6) | formula here | adenosine 6 mg (2 mL) Injection |
Adrenaline (epinephrine) 1:10,000 (Adrenaline - Link 100338) Injection 1mg/10mL, 10mL (10) | adenosine 6 mg (2 mL) Injection | ||
Adrenaline (epinephrine) 1:10,000 (Aguettant) PREFILLED SYRINGE 1mg/10mL, 10mL (10) | adrenaline (epinephrine) 1:1,000 1 mg (1 mL) Injection | ||
Adrenaline (epinephrine) 1:1000 (Aspen) Injection 1mg/mL, 1mL (5) | adrenaline (epinephrine) 1:1,000 1 mg (1 mL) Injection | ||
Aminophylline (DBL) Injection 250mg/10mL (5) | adrenaline (epinephrine) 1:10,000 1 mg (10 mL) Injection | ||
Amiodarone (Cordarone X) Injection 150mg/3mL (6) | adrenaline (epinephrine) 1:10,000 1 mg (10 mL) Injection | ||
Ampicillin (Austrapen) Injection 1g (5) | adrenaline (epinephrine) 1:10,000 1 mg (10 mL) Prefilled Syringe | ||
Aqueous Cream (Pharmacy Select) Cream 100g (1) | adrenaline (epinephrine) 1:10,000 1 mg (10 mL) Prefilled Syringe | ||
Atracurium (Tracrium) Injection 25mg/2.5mL (5) | Albumin, Human 200 g/1 L (100 mL) Bottle | ||
Atropine (Pfizer) Injection 1.2mg/mL, 1mL (50) | Albumin, Human 40 g/1 L (500 mL) Bottle | ||
Benzatropine (Phebra) Injection 2mg/2mL (5) | alfentanil 1 mg (2 mL) Injection | ||
Benzoin Compound (Friar's balsam) Tincture 25mL (1) | alfentanil 1 mg (2 mL) Injection | ||
Benzylpenicillin (BenPen) Injection 1.2g (1) | alfentanil 5 mg (10 mL) Injection | ||
Benzylpenicillin (BenPen) Injection 600mg (1) | alfentanil 5 mg (10 mL) Injection | ||
Betamethasone (Celestone Chronodose) Injection 5.7mg/mL (5) | amiNOPHYLLine 250 mg (10 mL) Injection | ||
Bismuth - Iodoform - Paraffin (BIP Paste Gauze) Dressing 12.5mm x 1m (1) | amiNOPHYLLine 250 mg (10 mL) Injection | ||
Bupivacaine - Glucose (Marcain Spinal Heavy) Injection 0.5%-8% (5 x 4mL) | amiODAROne 150 mg (3 mL) Injection | ||
Bupivacaine (Marcain Epidural) Epidural infusion 0.125%, 200mL (5) | amiODAROne 150 mg (3 mL) Injection | ||