Bactrim susp

I need to create a way to look up patients by medication. The data (much simplified) has 2 columns with column A being the patient ID number (1-20 in this example) and column B being the semicolon delimited list of medications that the patient is taking.
Medication descriptions sometimes contain commas. Medication dosages need not be included.
What would be the best way to help an end user look up patients by medication? (There are approximately 14,000 rows of patients in the spreadsheet that I am working with.)
1 AMOXICILLIN 500 MG CAPSULE; AMOXICILLIN 500 MG TABLET; CLARITHROMYCIN 500 MG TABLET; CLONIDINE HCL 0.3 MG TABLET; ERGOCALCIFEROL (VITAMIN D2) 1,250 MCG (50,000 UNIT) CAPSULE; IRBESARTAN 150 MG TABLET; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE; PRAVASTATIN 10 MG TABLET; PREDNISOLONE ACETATE 1 % EYE DROPS,SUSPENSION; TOBRAMYCIN 0.3 %-DEXAMETHASONE 0.1 % EYE DROPS,SUSPENSION; ULTIMATE FLORA PROBIOTIC 30 BILLION CELL CAPSULE,DELAYED RELEASE
2 AMLODIPINE 5 MG TABLET; ASPIRIN 81 MG TABLET,DELAYED RELEASE; BAYER ASPIRIN 325 MG TABLET; BENAZEPRIL 40 MG TABLET; CYCLOBENZAPRINE 10 MG TABLET; ERYTHROMYCIN 5 MG/GM OINT; HYDROCHLOROTHIAZIDE 25 MG TABLET; KLOR-CON M10 MEQ TABLET,EXTENDED RELEASE; LEVETIRACETAM 1,000 MG TABLET; METHOCARBAMOL 750 MG TABLET; MUPIROCIN 2 % TOPICAL OINTMENT; NEOMYCIN 3.5 MG/G-POLYMYXIN B 10,000 UNIT/G-DEXAMETH 0.1 % EYE OINT; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE(PART/CRYST); PREDNISONE 20 MG TABLET; TRAMADOL 50 MG TABLET; VOLTAREN 1 % TOPICAL GEL
3 ACETAMINOPHEN 325 MG TABLET; ASPIRIN 81 MG CHEWABLE TABLET; BRIMONIDINE 0.2 % EYE DROPS; DONEPEZIL 10 MG TABLET; ROSUVASTATIN 20 MG TABLET; SULFAMETHOXAZOLE 800 MG-TRIMETHOPRIM 160 MG TABLET; TRAZODONE 50 MG TABLET
4 AMLODIPINE 10 MG TABLET; BACLOFEN 10 MG TABLET; CARDIZEM CD 240 MG CAPSULE,EXTENDED RELEASE; CIALIS 20 MG TABLET; CYCLOBENZAPRINE 10 MG TABLET; DEPO-MEDROL 40 MG/ML SUSPENSION FOR INJECTION; DILTIAZEM CD 240 MG CAPSULE,EXTENDED RELEASE 24 HR; HYDROCODONE 10 MG-ACETAMINOPHEN 325 MG TABLET; IBUPROFEN 800 MG TABLET; METFORMIN 500 MG TABLET; MOBIC 15 MG TABLET; ROSUVASTATIN 40 MG TABLET; VALSARTAN 320 MG-HYDROCHLOROTHIAZIDE 12.5 MG TABLET
5 CLARITIN 10 MG TABLET; CYCLOBENZAPRINE 10 MG TABLET; CYCLOBENZAPRINE 5 MG TABLET; DICLOFENAC SODIUM 75 MG TABLET,DELAYED RELEASE; FLUTICASONE PROPIONATE 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; GAS RELIEF (SIMETHICONE); MUCINEX 1,200 MG TABLET, EXTENDED RELEASE; PEN NEEDLE 32 GAUGE X 5/32"; TRAMADOL 50 MG TABLET; VICTOZA 3-PAK 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR
6 AMLODIPINE 10 MG TABLET; AMLODIPINE 5 MG TABLET; CHLORTHALIDONE 25 MG TABLET; DICLOFENAC 1 % TOPICAL GEL; FLUTICASONE PROPIONATE 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; LISINOPRIL 40 MG TABLET; LORATADINE 10 MG TABLET; POTASSIUM CHLORIDE ER 10 MEQ CAPSULE,EXTENDED RELEASE; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE(PART/CRYST)
7 AMLODIPINE 10 MG TABLET; ASPIRIN 81 MG TABLET,DELAYED RELEASE; ATORVASTATIN 40 MG TABLET; CELEBREX 200 MG CAPSULE; CELECOXIB 200 MG CAPSULE; CYANOCOBALAMIN (VIT B-12) 1,000 MCG/ML INJECTION SOLUTION; DHEA 25 MG CAPSULE; ERGOCALCIFEROL (VITAMIN D2) 1,250 MCG (50,000 UNIT) CAPSULE; HYDROCODONE 5 MG-ACETAMINOPHEN 325 MG TABLET; LIDOCAINE HCL 10 MG/ML (1 %) INJECTION SOLUTION; LOSARTAN 100 MG-HYDROCHLOROTHIAZIDE 12.5 MG TABLET; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE; TESTOSTERONE CYPIONATE 200 MG/ML INTRAMUSCULAR OIL; TRAMADOL 50 MG TABLET
8 ALBUTEROL SULF 90 MCG/ACTUATION BREATH ACTIVATED POWDER INHALER,SENSOR; ALBUTEROL SULFATE 2.5 MG/3 ML (0.083 %) SOLUTION FOR NEBULIZATION; ALLERGY RELIEF (FEXOFENADINE) 180 MG TABLET; AMLODIPINE 10 MG TABLET; APLISOL 5 TUB. UNIT/0.1 ML INTRADERMAL INJECTION SOLUTION; ATORVASTATIN 20 MG TABLET; AZELASTINE 137 MCG (0.1 %) NASAL SPRAY AEROSOL; BENZONATATE 100 MG CAPSULE; CLARITIN 10 MG TABLET; CLOPIDOGREL 75 MG TABLET; CULTURELLE DIGESTIVE HEALTH 10 BILLION CELL-200 MG CAPSULE; DALIRESP 250 MCG TABLET; FLONASE ALLERGY RELIEF 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; FLUCONAZOLE 200 MG TABLET; FLUTICASONE PROPIONATE 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; FUROSEMIDE 20 MG TABLET; GABAPENTIN 300 MG CAPSULE; HYDROCODONE 10 MG-ACETAMINOPHEN 325 MG TABLET; HYDROXYZINE PAMOATE 25 MG CAPSULE; IPRATROPIUM 0.5 MG-ALBUTEROL 3 MG (2.5 MG BASE)/3 ML NEBULIZATION SOLN; LIDOCAINE 5 % TOPICAL OINTMENT; LORATADINE 10 MG CAPSULE; LORATADINE 10 MG TABLET; MONTELUKAST 10 MG TABLET; MUPIROCIN 2 % TOPICAL OINTMENT; ONDANSETRON 4 MG DISINTEGRATING TABLET; PANTOPRAZOLE 40 MG TABLET,DELAYED RELEASE; PAPAYA ENZYME (AMYLASE-PROTEASE) 50 MCG-1 MG-10 MG-10 MG CHEW TABLET; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE; PREDNISONE 50 MG TABLET; PROAIR HFA 90 MCG/ACTUATION AEROSOL INHALER; TESSALON PERLES 100 MG CAPSULE; TIZANIDINE 4 MG TABLET; TRAZODONE 50 MG TABLET; TRELEGY ELLIPTA; TRIAMCINOLONE ACETONIDE 0.1 % TOPICAL CREAM; VENLAFAXINE ER 37.5 MG CAPSULE,EXTENDED RELEASE 24 HR; VENLAFAXINE ER 75 MG CAPSULE,EXTENDED RELEASE 24 HR; VITAMIN B COMPLEX TABLET; VITAMIN C 1,000 MG TABLET; VITAMIN D3 100 MCG (4,000 UNIT) CAPSULE; VITAMIN D3 50 MCG (2,000 UNIT) CAPSULE
9 CETIRIZINE 10 MG TABLET; OMEPRAZOLE 20 MG CAPSULE,DELAYED RELEASE; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE
13 ALBUTEROL SULFATE 2.5 MG/3 ML (0.083 %) SOLUTION FOR NEBULIZATION; ALBUTEROL SULFATE HFA 90 MCG/ACTUATION AEROSOL INHALER; CETIRIZINE 10 MG TABLET; DEPO-MEDROL 40 MG/ML SUSPENSION FOR INJECTION; ERGOCALCIFEROL (VITAMIN D2) 1,250 MCG (50,000 UNIT) CAPSULE; IMITREX 50 MG TABLET; LISINOPRIL 20 MG-HYDROCHLOROTHIAZIDE 25 MG TABLET; MONTELUKAST 10 MG TABLET; PROAIR HFA 90 MCG/ACTUATION AEROSOL INHALER; SUMATRIPTAN 50 MG TABLET
11 AMLODIPINE 5 MG TABLET; ASPIRIN 81 MG CHEWABLE TABLET; ATORVASTATIN 40 MG TABLET; BRIMONIDINE 0.2 % EYE DROPS; BYSTOLIC 10 MG TABLET; CHLORTHALIDONE 25 MG TABLET; CHOLECALCIFEROL (VITAMIN D3) 125 MCG (5,000 UNIT) CAPSULE; DICLOFENAC 1 % TOPICAL GEL; DORZOLAMIDE 22.3 MG-TIMOLOL 6.8 MG/ML EYE DROPS; LOSARTAN 50 MG TABLET; PANTOPRAZOLE 40 MG TABLET,DELAYED RELEASE; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE(PART/CRYST); PROTONIX 40 MG TABLET,DELAYED RELEASE; TRAVATAN Z 0.004 % EYE DROPS; VOLTAREN 1 % TOPICAL GEL
12 BD INSULIN SYRINGE ULTRA-FINE 1 ML 30 GAUGE X 1/2"; CALCITRIOL 0.25 MCG CAPSULE; CLONIDINE HCL 0.3 MG TABLET; CLOPIDOGREL 75 MG TABLET; CYCLOBENZAPRINE 10 MG TABLET; DOXAZOSIN 4 MG TABLET; ERGOCALCIFEROL (VITAMIN D2) 1,250 MCG (50,000 UNIT) CAPSULE; FEROSUL 325 MG (65 MG IRON) TABLET; FOLIC ACID 1 MG TABLET; FREESTYLE LANCETS 28 GAUGE; FREESTYLE LITE STRIPS; FUROSEMIDE 40 MG TABLET; GLIPIZIDE 10 MG TABLET; GLUCOTROL 10 MG TABLET; HUMULIN 70/30 U-100 INSULIN 100 UNIT/ML SUBCUTANEOUS SUSPENSION; HYDRALAZINE 25 MG TABLET; HYDROCHLOROTHIAZIDE 12.5 MG CAPSULE; HYDROCODONE 7.5 MG-ACETAMINOPHEN 325 MG TABLET; IPRATROPIUM 0.5 MG-ALBUTEROL 3 MG (2.5 MG BASE)/3 ML NEBULIZATION SOLN; ISOSORBIDE MONONITRATE ER 30 MG TABLET,EXTENDED RELEASE 24 HR; METOPROLOL TARTRATE 25 MG TABLET; MINOXIDIL 2.5 MG TABLET; NIFEDIPINE ER 60 MG TABLET,EXTENDED RELEASE; NITROGLYCERIN 0.4 MG/HR TRANSDERMAL 24 HOUR PATCH; NOVOLIN 70/30 U-100 INSULIN 100 UNIT/ML SUBCUTANEOUS SUSPENSION; PANTOPRAZOLE 40 MG TABLET,DELAYED RELEASE; POTASSIUM CHLORIDE ER 10 MEQ TABLET,EXTENDED RELEASE; SPIRIVA WITH HANDIHALER 18 MCG AND INHALATION CAPSULES; SURE COMFORT INSULIN SYRINGE 1 ML 30 GAUGE X 5/16"; ZOLPIDEM 10 MG TABLET
13 CEPHALEXIN 500 MG CAPSULE; TRIAMCINOLONE ACETONIDE 0.1 % DENTAL PASTE
14 ASPIRIN 81 MG TABLET; BIKTARVY 50 MG-200 MG-25 MG TABLET; BUTALBITAL 50 MG-ACETAMINOPHEN 325 MG TABLET; CIPRO 500 MG TABLET; DIAZEPAM 5 MG TABLET; OMEPRAZOLE; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE; PANTOPRAZOLE 40 MG TABLET,DELAYED RELEASE; VALIUM 5 MG TABLET
15 BACTRIM DS 800 MG-160 MG TABLET; LEVOTHYROXINE 112 MCG TABLET; METRONIDAZOLE 500 MG TABLET; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE; SYNTHROID 112 MCG TABLET; VITAMIN D3 50 MCG (2,000 UNIT) CAPSULE
16 CETIRIZINE 10 MG TABLET; TRI-SPRINTEC (28) 0.18 MG(7)/0.215 MG(7)/0.25 MG(7)-35 MCG TABLET; TRIAMCINOLONE ACETONIDE 0.1 % TOPICAL CREAM
17 DOCUSATE SODIUM 100 MG CAPSULE; DOXYCYCLINE HYCLATE 100 MG TABLET; FEROSUL 325 MG (65 MG IRON) TABLET; FERROUS GLUCONATE 324 MG (38 MG IRON) TABLET; FERROUS SULFATE 325 MG (65 MG IRON) TABLET; FUROSEMIDE 20 MG TABLET; IPRATROPIUM 0.5 MG-ALBUTEROL 3 MG (2.5 MG BASE)/3 ML NEBULIZATION SOLN; K-TAB 20 MEQ TABLET,EXTENDED RELEASE; LORAZEPAM 0.5 MG TABLET; METOCLOPRAMIDE 5 MG TABLET; METRONIDAZOLE 500 MG TABLET; MIDODRINE 5 MG TABLET; ONDANSETRON 4 MG DISINTEGRATING TABLET; OXYBUTYNIN CHLORIDE ER 10 MG TABLET,EXTENDED RELEASE 24 HR; OXYCODONE 15 MG TABLET; PANTOPRAZOLE 40 MG TABLET,DELAYED RELEASE; POTASSIUM CHLORIDE ER 20 MEQ TABLET,EXTENDED RELEASE; STOOL SOFTNR100MG CAP; TRAMADOL 50 MG TABLET
18 AMLODIPINE 5 MG TABLET; DICYCLOMINE 10 MG CAPSULE; GEMFIBROZIL 600 MG TABLET; IBUPROFEN 800 MG TABLET; LOSARTAN 100 MG-HYDROCHLOROTHIAZIDE 25 MG TABLET; NAPROXEN 500 MG TABLET; OMEPRAZOLE 20 MG CAPSULE,DELAYED RELEASE; OMEPRAZOLE 40 MG CAPSULE,DELAYED RELEASE
19 ADVAIR DISKUS 250 MCG-50 MCG/DOSE POWDER FOR INHALATION; ALPRAZOLAM 2 MG TABLET; AMOXICILLIN 500 MG CAPSULE; BLOOD GLUCOSE TEST STRIPS; BUTALBITAL-ACETAMINOPHEN-CAFFEINE 50 MG-325 MG-40 MG TABLET; CITALOPRAM 20 MG TABLET; CYANOCOBALAMIN (VIT B-12) 1,000 MCG/ML INJECTION SOLUTION; DEXILANT 60 MG CAPSULE, DELAYED RELEASE; DILTIAZEM CD 240 MG CAPSULE,EXTENDED RELEASE 24 HR; DIOVAN HCT 160 MG-12.5 MG TABLET; ELIQUIS 5 MG TABLET; FAMOTIDINE 40 MG TABLET; FERROUS SULFATE 325 MG (65 MG IRON) TABLET,DELAYED RELEASE; FLECAINIDE 100 MG TABLET; FLONASE ALLERGY RELIEF 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; FLUTICASONE PROPIONATE 50 MCG/ACTUATION NASAL SPRAY,SUSPENSION; FOLIC ACID 1 MG TABLET; FREESTYLE LANCETS 28 GAUGE; FREESTYLE LITE METER KIT; FREESTYLE LITE STRIPS; IPRATROPIUM 0.5 MG-ALBUTEROL 3 MG (2.5 MG BASE)/3 ML NEBULIZATION SOLN; LYRICA 150 MG CAPSULE; MAGNESIUM OXIDE 400 MG (241.3 MG MAGNESIUM) TABLET; METFORMIN 500 MG TABLET; METHYLPREDNISOLONE 4 MG TABLETS IN A DOSE PACK; METOPROLOL SUCCINATE ER 100 MG TABLET,EXTENDED RELEASE 24 HR; MONTELUKAST 10 MG TABLET; NEOMYCIN-POLYMYXIN-HYDROCORT 3.5 MG-10,000 UNIT/ML-1 % EAR DROPS,SUSP; NITROSTAT 0.4 MG SUBLINGUAL TABLET; OXYCODONE-ACETAMINOPHEN 10 MG-325 MG TABLET; POTASSIUM CHLORIDE ER 20 MEQ TABLET,EXTENDED RELEASE(PART/CRYST); PREDNISONE 20 MG TABLET; PROAIR HFA 90 MCG/ACTUATION AEROSOL INHALER; PROMETHAZINE 12.5 MG TABLET; PROVENTIL HFA 90 MCG/ACTUATION AEROSOL INHALER; REQUIP 5 MG TABLET; ROPINIROLE 0.5 MG TABLET; SINGULAIR 10 MG TABLET; TECHLITE PEN NEEDLE 32 GAUGE X 5/32"; TIZANIDINE 4 MG TABLET; TORSEMIDE 100 MG TABLET; TRAZODONE 100 MG TABLET; VALSARTAN 160 MG-HYDROCHLOROTHIAZIDE 12.5 MG TABLET; VENLAFAXINE 37.5 MG TABLET; VICTOZA 2-PAK 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR; VICTOZA 3-PAK 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR
20 ADVAIR DISKUS 500 MCG-50 MCG/DOSE POWDER FOR INHALATION; ATORVASTATIN 40 MG TABLET; ATROPINE 1 % EYE DROPS; CETIRIZINE 10 MG TABLET; DOXYCYCLINE HYCLATE 100 MG CAPSULE; LATANOPROST 0.005 % EYE DROPS; LISINOPRIL 10 MG-HYDROCHLOROTHIAZIDE 12.5 MG TABLET; OMEPRAZOLE 20 MG CAPSULE,DELAYED RELEASE; OMEPRAZOLE 20 MG TABLET,DELAYED RELEASE; ONE A DAY; OXYCODONE-ACETAMINOPHEN 5 MG-325 MG TABLET; PHENYTOIN SODIUM EXTENDED 100 MG CAPSULE; PREDNISOLONE ACETATE (PF) 1 % EYE DROPS,SUSPENSION; PROAIR HFA 90 MCG/ACTUATION AEROSOL INHALER; PROVENTIL HFA 90 MCG/ACTUATION AEROSOL INHALER; VIGAMOX 0.5 % EYE DROPS