Best Match (Fuzzy Match Alternative) for Product Description and Pulling Respective Product ID Code

SkywardPalm

Board Regular
Joined
Oct 23, 2021
Messages
61
Office Version
  1. 365
Platform
  1. Windows
I'm looking for the most efficient way to find the best matching cell (based on a product's description text) and pull the product ID code from a reference sheet into a separate (product ID code) column on the initial sheet. The product's description needs to be compared to the entirety of a separate worksheet's product descriptions and decide which is the best fit for pulling the product code. I've looked into Fuzzy Matching, but I would prefer a method that I could automate with VBA in the future. For now, I'm simply looking for a method that would be the most accurate and not simply compare the position of letters/numbers in each cell. It would take into account the name, strength, and dose form within the description of these products (which are drugs specifically) and find the best match based on these identifiers. The initial file might contain abbreviations, or partial word descriptions. The initial sheet can range from 100-10,000's of line items, whereas the reference sheet has nearly 300k items to compare with. The reference sheet would be sorted by Product ID, then the date it was last acquired so that the first pulled Product ID would be the most accurate.

(Initial Sheet for LookUp)
Product ID Lookup (Initial).xlsx
AB
1Product IDProduct Description
2acetamin-codeine 300-30 mg 1ea TAB
3acetaminophen 10mg/1mL 100mL INJ
4acetaminophen 120mg SUPP
5acetaminophen 160mg/5mL 5mL PO LIQ
6acetaminophen 325mg SUPP
7acetaminophen 325mg tablet
8acetaminophen 500mg TAB
9acetaminophen 650mg SUPP
10acetaminophen 650mg/20.29mL 20.29mL ORAL SU
11acetylcysteine 10% 100mg/1mL 4mL INH
12acetylcysteine 20% 200mg/1mL 4mL INH
13acetylcysteine 200mg/1mL 4mL SOLN
14Acyclovir 400mg TAB
15adenosine 3mg/1mL 2mL INJ
16albumin human 25% 12.5g/50mL 50mL IV SOLN
17albumin human 25% 25g/100mL 100mL IV SOLN
18albumin human 5% 12.5g/250mL 250mL IV SOLN
19albumin human 5% 25g/500mL 500mL SOLN
20albuterol 2.5mg/3mL 3mL NEB AMP
21albuterol HFA 90 mcg/inh 90mcg INHALER
22albuterol-ipratropium 3-0.5 mg/3 mL 1EA INH
23Allopurinol 100mg TAB
24ALPRAZolam 0.25mg TAB
25ALPRAZolam 0.5mg TAB
26ALPRAZolam 1mg TAB
27Alteplase 100mg VIAL
28Alu-Mg Hydrx/Sim 1200-1200-120mg 30mL LIQD
29Aminocaproic Acid 250mg/1mL 20mL VIAL
30Amiodarone (Pre-mix) 150mg/100mL 100mL IVPB
31Amiodarone (Pre-mix) 360mg/200mL 200mL IVPB
32Amiodarone 200mg TAB
33Amiodarone 50mg/1mL 3mL VIAL
34amLODIPine 10mg TAB
35amLODIPine 5mg TAB
Needs Product ID


(Reference Sheet)
Product Reference Book.xlsx
AB
1Product IDProduct Description
200053768032ALBUMINAR-25 VIAL 25 % 50
300053768033ALBUMINAR-25 VIAL 25 % 100
400093005001ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
500093363020Acyclovir 50 mg/g CREAM
600228202750ALPRAZOLAM TABLET 0.25 MG 500
700228202796ALPRAZOLAM TABLET 0.25 MG 1000
800228202950ALPRAZOLAM TABLET 0.5 MG 500
900228202996ALPRAZOLAM TABLET 0.5 MG 1000
1000406048301ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
1100409193201ADENOSINE VIAL 3 MG/ML 20
1200409193202ADENOSINE VIAL 3 MG/ML 30
1300536132710ACETAMINOPHEN 325 MG TAB 1000
1400703877601ADENOSINE VIAL 3 MG/ML 20
1500703877701ADENOSINE VIAL 3 MG/ML 30
1600781107705ALPRAZOLAM TABLET 0.5 MG 500
1700781107710ALPRAZOLAM TABLET 0.5 MG 1000
1800781729685ALBUTEROL SULF HFA 90 MCG INH
1900904578961ACYCLOVIR CAPSULE 200 MG 100
2000904579061ACYCLOVIR TABLET 400 MG 100
2100904672024ACETAMINOPHEN TABLET 500 MG 24
2210702018501OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
2313107005801ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
2417478054202ADENOSINE VIAL 3 MG/ML 2
2517478054225ADENOSINE VIAL 3 MG/ML 2
2617478054420ADENOSINE VIAL 3 MG/ML 20
2717478054430ADENOSINE VIAL 3 MG/ML 30
2817478095302ADENOSINE VIAL 3 MG/ML 2
2923155022701ACYCLOVIR TABLET 400 MG 100
3023155022705ACYCLOVIR TABLET 400 MG 500
3125021030720ADENOSINE VIAL 3 MG/ML 20
3231722077701ACYCLOVIR TABLET 400 MG 100
3331722077705ACYCLOVIR TABLET 400 MG 500
3431722094901OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
3531722094905OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
3631722095001OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
3731722095101OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
3831722095105OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
3931722099601Hydrocodone Bitartrate and Acetaminophen 5; 325 mg/1; mg/1 ORAL TABLET
4031722099701Hydrocodone Bitartrate and Acetaminophen 10; 325 mg/1; mg/1 ORAL TABLET
4142858010350OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
4242858013901HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 100HYDROCODONE-ACETAMINOPHEN 7.
4343386035610HYDROCODONE-ACETAMINOPHEN TABLET 5MG-325MG 1000
4443386035801HYDROCODONE-ACETAMINOPHEN TABLET 10-325MG 100
4543386035810HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 1000HYDROCODONE-ACETAMINOPHEN 1
4645802073000ACETAMINOPHEN 650 MG SUPPOS
4745802073030ACETAMINOPHEN SUPP.RECT 650 MG 12
4845802073032ACETAMINOPHEN SUPP.RECT 650 MG 50
4945802073033ACETAMINOPHEN SUPP.RECT 650 MG 100
5045802073200ACETAMINOPHEN 120 MG SUPPOS
5145802073230ACETAMINOPHEN SUPP.RECT 120 MG 12
5245802073233ACETAMINOPHEN SUPP.RECT 120 MG 100
5346122031278ACETAMINOPHEN EXTRA STRENGTH CAPSULE 500MG 100
5446122042462ACETAMINOPHEN TABLET 160 MG 24Pain Relief 160 mg/1 TABLET, CHEWABLE
5546122043078ACETAMINOPHEN TABLET 325MG 100
5646122064971Acetaminophen 500 mg/1 ORAL TABLET, FILM COATED
5747781022905OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
5849483034010ACETAMINOPHEN TABLET 325 MG 1000ACETAMINOPHEN 325 MG TABLET
5950268040015HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 50
6050268040115HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 50
6150268040215HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 50
6250268064415OXYCODONE-ACETAMINOPHEN TABLET 5MG-325MG 50
6350268064615OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 50
6450268077415TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 50
6550383033705Acetaminophen and Codeine Phosphate 120; 12 mg/5mL; mg/5mL ORAL SOLUTION
6650383033706Acetaminophen and Codeine Phosphate 120; 12 mg/5mL; mg/5mL ORAL SOLUTION
6751407014501ACYCLOVIR TABLET 400 MG 100
6851672422201Butalbital, Acetaminophen and Caffeine 50; 300; 40 mg/1; mg/1; mg/1 ORAL C
6951862017901BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-325-40 100
7051991070405ALPRAZOLAM TABLET 0.25 MG 500
7153746061701TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
7253746061710TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 1000
7354859080916Liquid Acetaminophen 160 mg/5mL ORAL LIQUID
7457664053788TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
7557896010210ACETAMINOPHEN TABLET 325 MG 1000ACETAMINOPHEN 325 MG TABLET
7657896020005ACETAMINOPHEN TABLET 500 MG 50
7757896020401ACETAMINOPHEN TABLET 500 MG 100ACETAMINOPHEN 500 MG TABLET
7857896026801ACETAMINOPHEN TB 650MGGERI100@
7958602022124ACETAMIN OS 160MG/5ML AURO4OZ@
8059762371903ALPRAZOLAM TABLET 0.25 MG 500
8159762371904ALPRAZOLAM TABLET 0.25 MG 1000
8259762372003ALPRAZOLAM TABLET 0.5 MG 500
8359762372004ALPRAZOLAM TABLET 0.5 MG 1000
8460505004206ACYCLOVIR CAPSULE 200 MG 100
8560505530601ACYCLOVIR TABLET 400 MG 100
8660687040701HYDROCODONE-ACETAMINOPHEN TABLET 7.5-500 MG 100
8760687041771HYDROCODONE-ACETAMINOPHEN SOLUTION 7.5-325/15 15HYDROCODONE-ACETAMINOPHEN 7
8860687057124acetaminophen 650mg/20.30ml american health
8960687057156ACETAMINOPHEN 325 MG SOL 100X1
9061442011201ACYCLOVIR TABLET 400 MG 100
9161442011205ACYCLOVIR TABLET 400 MG 500
9262991100202ACETAMINOPHEN POWDER 100 % 500
9363323043400Acetaminophen 10 mg/mL INTRAVENOUS INJECTION
9463323065102ADENOSINE VIAL 3 MG/ML 2
9563323065120ADENOSINE VIAL 3 MG/ML 20
9663323065130ADENOSINE VIAL 3 MG/ML 30
9763629214001Butalbital, Acetaminophen and Caffeine 50; 325; 40 mg/1; mg/1; mg/1 ORAL T
9863739044001ACETAMINOPHEN TABLET 325 MG 750
9963739068210ACYCLOVIR TABLET 400 MG 100
10065162011510HYDROCODONE-ACETAMINOPHEN TABLET 7.5-650 MG 100
10165162011550HYDROCODONE-ACETAMINOPHEN TABLET 7.5-650 MG 500
10265862092201TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
10365862092205TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 500
10466689000550HYDROCODONE-ACETAMINOPHEN SOLUTION 5-217MG/10 10HYDROCODONE-ACETAMINOPHEN 5
10566689002304HYDROCODONE-ACETAMINOPHEN SOLUTION 7.5-325/15 120
10666689005499ACETAMINOPHEN SOLUTION 160 MG 5
10766689005699ACETAMINOPHEN SOLUTION 650 MG 20.3
10867253090011ALPRAZOLAM TABLET 0.25 MG 1000
10967253090050ALPRAZOLAM TABLET 0.25 MG 500
11067253090111ALPRAZOLAM TABLET 0.5 MG 1000
11167253090150ALPRAZOLAM TABLET 0.5 MG 500
11267457085502ADENOSINE VIAL 3 MG/ML 2
11367457085730ADENOSINE VIAL 3 MG/ML 30
11467457094010Acetaminophen 1000 mg/100mL INTRAVENOUS INJECTION, SOLUTION
11568001049500ACETAMINOPHEN 650 MG ER TAB 100
11668047072130BUTALBITAL-ACETAMINOPHEN TABLET 50MG-325MG 30BUTALBITAL-ACETAMINOPHEN 50-32
11768084010701ACYCLOVIR CAPSULE 200 MG 100
11868084010801ACYCLOVIR TABLET 400 MG 100
11968084077725ACETAMINOPHEN ER TABLET ER 650 MG 30
12068084082501TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
12168084089509HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 80
12268094003062Acetaminophen 650 mg/20.3mL SUSPENSION
12368094058658CHILDREN'S ACETAMINOPHEN SYRINGE 80MG/2.5ML 2.5
12468094058758CHILDREN'S ACETAMINOPHEN SYRINGE 160 MG/5ML 5
12568094058862CHILDREN'S ACETAMINOPHEN ORAL SUSP 325/10.15 10.15
12668382079101ACYCLOVIR TABLET 400 MG 100
12768382079105ACYCLOVIR TABLET 400 MG 500
12868682030601BUTALBITAL-ACETAMINOPHEN TABLET 50MG-300MG 100
12969076014601ACYCLOVIR CAPSULE 200 MG 100
13069367020305BUTALBITAL-ACETAMINOPHEN-CAFFE TABLET 50-325-40 500BUTALBITAL-ACETAMINOPHEN
13170000003601Acetaminophen 500 mg/1 TABLET
13270000006601Acetaminophen, Aspirin, Caffeine 250; 250; 65 mg/1; mg/1; mg/1 ORAL TABLET
13370000030901CHILDREN'S ACETAMINOPHEN TAB CHEW 160MG 24
13470000031001CHILDREN'S ACETAMINOPHEN TAB CHEW 160 MG 24
13570000031201ACETAMINOPHEN TABLET 500MG 50
13670000037302ACETAMINOPHEN TABLET 500 MG 50
13770000041101ACETAMINOPHEN PM TABLET 500MG-25MG 24ACETAMINOPHEN PM CAPLET
13870000041102ACETAMINOPHEN PM TABLET 500MG-25MG 50ACETAMINOPHEN PM CAPLET
13970000041103ACETAMINOPHEN PM TABLET 500MG-25MG 100ACETAMINOPHEN PM CAPLET
14070000050901Leader Extra Strength Acetaminophen 500 mg/1 CAPSULE, LIQUID FILLED
14170010004401Butalbita,Acetaminophen and Caffeine 50; 300; 40 mg/1; mg/1; mg/1 ORAL CAP
14270092143546ACETAMINOPHEN SYRINGE 10 MG/ML 10
14371205098130Butalbital, Acetaminophen, Caffeine 50; 325; 40 mg/1; mg/1; mg/1 ORAL TABL
14471399802701ACETAMINOPHEN ES 500 MG TAB 100
14571930001912HYDROCODONE-ACETAMINOPHEN TABLET 5MG/325MG 100
14671930002112HYDROCODONE-ACETAMINOPHEN TABLET 10-325 100
14771930002152HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500HYDROCODONE-ACETAMINOPHEN 10
14871930004612OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
14971930005552ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 500
15075834012401ACYCLOVIR CAPSULE 200 MG 100
15181033000250ACETAMIN160MG/5ML UD CUPKES50@
15296295013134acetaminophen (TYLENOL) 650 MG TbSR 50 EA
15300067820001Acetaminophen, Dextromethorphan HBr, Phenylephrine HCl, Diphenhydramine HCl
15400067820304Acetaminophen, Aspirin (NSAID), and Caffeine
15500093035010ACETAMINOPHEN-CODEINE TABLET 300MG-60MG 1000
15600113039726acetaminophen
15700113043778Acetaminophen, Diphenhydramine HCl
15800113076334Acetaminophen, Dextromethorphan HBr, Doxylamine Succinate, Phenylephrine HCl
15900113090326Acetaminophen, Chlorpheniramine Maleate, Dextromethorphan HBr, Phenylephrine HCl
16000113700078Basic Care acetaminophen 500 mg/1 TABLET, FILM COATED
16100113700079BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET, FILM COATED
16200113743778basic care acetaminophen PM 500; 25 mg/1; mg/1 TABLET, FILM COATED
16300113748482basic care acetaminophen 500 mg/1 TABLET
16400113748483BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET
16500113748490BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET
16600113754479Basic Care Acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
16700121078104Childrens Acetaminophen
16800121093900Childrens Acetaminophen 160 mg/5mL ORAL SUSPENSION
16900121094100Acetaminophen Oral Suspension 160mg/5mL UD CUP
17000121094194Acetaminophen Oral Suspension 160mg/5mL UD CUP
17100121094600Childrens Acetaminophen Oral Suspension 160mg/5mL UD Cup
17200121094630Childrens Acetaminophen Oral Suspension 160mg/5mL UD Cup
17300121187800Childrens Acetaminophen 360 mg/10mL ORAL SUSPENSION
17400121188200Acetaminophen 325mg/10.15mL Suspension UD Cup
17500121188294Acetaminophen 325mg/10.15mL Suspension UD Cup
17600121282394ACETAMINOPHEN 650 MG/20.3 ML UD CUP
17700135701101acetaminophen
17800135701102acetaminophen
17900135701104acetaminophen
18000135702101acetaminophen and diphenhydramine HCl
18100245041001Hydrocodone Bitartrate and Acetaminophen 5; 325 mg/1; mg/1 TABLET
18200245041011HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
18300245041050HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
18400245041101Hydrocodone Bitartrate and Acetaminophen 7.5; 325 mg/1; mg/1 TABLET
18500245041111HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
18600245041150HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
18700245041201Hydrocodone Bitartrate and Acetaminophen 10; 325 mg/1; mg/1 TABLET
18800245041211HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
18900245041250HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
19000264405080ACETAMINOPHEN 10MG/ML 24X50 IP
19100280002202chlorpheniramine maleate, acetaminophen, phenylephrine hydrochloride, dextromethorphan hydrobromide
19200280005501chlorpheniramine maleate, dextromethorphan hydrobromide, acetaminophen, phenylephrine hydrochloride
19300363033422Acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
19400363033455Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
19500363033602Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
19600363033624Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
19700363034008Acetaminophen 650 mg/1 TABLET, EXTENDED RELEASE
19800363697302Extra Strength Acetaminophen 500 mg/1 ORAL TABLET
19900363979710Acetaminophen 500 mg/5001 ORAL TABLET
20000363999175Acetaminophen Diphenhydramine HCl 500; 25 mg/1; mg/1 ORAL TABLET
20100363999210Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
20200363999220Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
20300363999224Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
20400363999315Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
20500363999321Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
20600404071413Henry Schein Acetaminophen 325 mg/1 TABLET, FILM COATED
20700404071499HENRY SCHEIN ACETAMINOPHEN 325mg/1 ORAL TABLET, FILM COATED
20800404071613Henry Schein Acetaminophen 500 mg/1 TABLET, FILM COATED
20900406012310HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 1000
21000406012312HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 120
21100406012320HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
21200406012323HYDROCODONE-ACETAMINOPHEN 5-325 MG TABLET
21300406012330HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 30HYDROCODONE-ACETAMINOPHEN 5-3
21400406012360HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
21500406012390HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
21600406012412HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 120
21700406012420HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
21800406012423HYDROCODONE-ACETAMINOPHEN 7.5-325 MG TABLET
21900406012430HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
22000406012460HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
22100406012490HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
22200406012512HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 120
22300406012520HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
22400406012523HYDROCODONE-ACETAMINOPHEN 10-325 MG TABLET
22500406012530HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
22600406012560HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 60HYDROCODONE-ACETAMINOPHEN 10-
22700406012590HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
22800406037601HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 100
22900406037605HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500
23000406037623HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
23100406037662HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
23200406037705HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500
23300406037723HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
23400406037762HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
23500406037805HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500
23600406037823HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
23700406037862HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
23800406048420ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 20
23900406048450ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 50
24000406051291OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 5000
24100406052205OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
24200527164601HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 100HYDROCODONE-ACETAMINOPHEN 5-
24300527164605HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500HYDROCODONE-ACETAMINOPHEN 5-
24400527164701HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 100HYDROCODONE-ACETAMINOPHEN 7.
24500527164705HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500HYDROCODONE-ACETAMINOPHEN 7.
24600527164801HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 100HYDROCODONE-ACETAMINOPHEN 10
24700527164805HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500HYDROCODONE-ACETAMINOPHEN 10
24800527164905HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500HYDROCODONE-ACETAMINOPHEN 5-
24900527165005HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 500HYDROCODONE-ACETAMINOPHEN 7.
25000527165105HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500HYDROCODONE-ACETAMINOPHEN 10
25100527166901OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
25200527166905OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
25300527167101OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
25400527167105OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
25500527409437BUTALBITAL, ACETAMINOPHEN, AND CAFFEINE 50; 325; 40mg/1; mg/1; mg/1 ORAL CA
25600536129229Acetaminophen 500 mg/1 ORAL TABLET
25700536132706ACETAMINOPHEN 325 MG TAB 50
25800591264005BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-300-40 500
25900603233721ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
26000603389032HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 1000
26100615759039Acetaminophen Extended Release 650 mg/1 TABLET
26200615810239Acetaminophen and Codeine Phosphate 300; 30 mg/1; mg/1 TABLET
26300615825030Acetaminophen 500 mg/1 ORAL TABLET
26400615825039Acetaminophen 500 mg/1 TABLET
26500615827930Acetaminophen 325 mg/1 ORAL TABLET
26600615827939Acetaminophen 325 mg/1 TABLET
26700615828167Acetaminophen 325 mg/1 TABLET
26800615839730ACETAMINOPHEN
26900615839739ACETAMINOPHEN
27000615839867ACETAMINOPHEN
27100615840439Acetaminophen
27200641611310ADENOSINE VIAL 3 MG/ML 2
27300781106105ALPRAZOLAM TABLET 0.25 MG 500
27400781106110ALPRAZOLAM TABLET 0.25 MG 1000
27500781927495ACETAMIN 10MG/ML 10X100ML PPX SDV
27600924013100Acetaminophen, Aspirin, Caffeine
27700924013101Acetaminophen, Aspirin, Caffeine
27810702018410OXYCODONE AND ACETAMINOPHEN 2.5; 325mg/1; mg/1 ORAL TABLET
27910702018450OXYCODONE AND ACETAMINOPHEN 2.5; 325mg/1; mg/1 ORAL TABLET
28010702018510OXYCODONE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
28110702018550OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
28210702018601OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
28310702018610OXYCODONE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
28410702018650OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 500OXYCODONE-ACETAMINOPHEN 7.5-32
28510702018701OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
28610702018710OXYCODONE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
28710702018750OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
28810702018903HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
28910702019003HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
29010702019010HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 1000HYDROCODONE-ACETAMINOPHEN 7
29110702019103HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
29210702019110HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 1000HYDROCODONE-ACETAMINOPHEN 1
29310702019203HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
29410702019210HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
29510702019250HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500HYDROCODONE-ACETAMINOPHEN 5-
29610702019303HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
29710702019310HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
29810702019350HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500HYDROCODONE-ACETAMINOPHEN 7.
29910702019403HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
30010702019410HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
30110702019450HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500HYDROCODONE-ACETAMINOPHEN 10
30210702023850OXYCODONE AND ACETAMINOPHEN 5; 325mg/5mL; mg/5mL ORAL SOLUTION
30310702034301BENZHYDROCODONE-ACETAMINOPHEN TABLET 4.08-325MG 100
30410702034401BENZHYDROCODONE-ACETAMINOPHEN TABLET 6.12-325MG 100BENZHYDROCODONE-ACETAMIN
30510702034501BENZHYDROCODONE-ACETAMINOPHEN TABLET 8.16-325MG 100BENZHYDROCODONE-ACETAMIN
30611534018704BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-300-40 500
30711673010526ACETAMINOPHEN ORAL SUSP 160 MG/5ML 118
30811673013316ACETAMINOPHEN ORAL SUSP 160 MG/5ML 59
30911673013326up and up acetaminophen infants 160 mg/5mL ORAL SUSPENSION
31011673014808Acetaminophen 500 mg/1 TABLET
31111673034201ACETAMINOPHEN 500 mg/1 TABLET, FILM COATED
31211673034226ACETAMINOPHEN 500 mg/1 ORAL TABLET, FILM COATED
31311673034242ACETAMINOPHEN 500 mg/1 ORAL TABLET, FILM COATED
31411673043747up and up acetaminophen pm 500; 25 mg/1; mg/1 TABLET, FILM COATED
31511673043762up and up acetaminophen pm extra strength 500; 25 mg/1; mg/1 ORAL TABLET, F
31611673048471ACETAMINOPHEN TABLET 500 MG 50
31711673048483ACETAMINOPHEN TABLET 500 MG 225
31811673048490up and up acetaminophen extra strength 500 mg/1 ORAL TABLET
31911673051915ACETAMINOPHEN TABLET 500 MG 50
32011673051920ACETAMINOPHEN TABLET 500 MG 225
32111673061862Up and Up acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
32211673061878Up and Up acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEAS
32311673083801acetaminophen 500 mg/1 ORAL TABLET, COATED
32411673083805acetaminophen 500 mg/1 ORAL TABLET, COATED
32511673083826acetaminophen 500 mg/1 ORAL TABLET, COATED
32611673083850acetaminophen 500 mg/1 ORAL TABLET, COATED
Sheet1
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
I have tried the Fuzzy Lookup Add-In but it runs way too slow for the amount of data that I am working with. My excel is running on 64-bit and version 2202 of Office365. Any advice would be much appreciated.
 
Upvote 0
@Cawry
Is the actual data a sensitive material?
If not, could you upload a workbook (with the actual data) to a sharing site like dropbox.com or google drive?
And then share the link here.
I need the actual data to check if there are some patterns that can be used to find the best way to accomplish the job.
 
Upvote 0
@Akuini It's not sensitive, the reference data is directly from the FDA (available to the public). I'm using test data to attempt to find alternatives for finding the very best match between large data sets with very important items that have Look-alike/Sound-alike name descriptions where the strength and size (most of the time within the description) also matter.
Here is a link to Google Drive with a full sample.. It took Fuzzy Lookup 1.5 hours to find the 50 matches that are listed on the initial sheet.
Thanks for the response!
 
Upvote 0
Thanks for the file.
Sorry to say that I can see there are too many Product Descriptions that don't exactly match. And I can't find any patterns that can be used to find a match.
Hope somebody else can help you with this.

But I'm curious about the data entry process.
How do you enter Product Descriptions data that don't match the Product Descriptions in the reference sheet?
If you enter data via Excel, I suggest you use a searchable drop-down where you can type a few characters and select the correct item from a list (the list would populated from the reference sheet). This way you always get an exact match.
If you're interested, I created an Excel add-in, called "Search deList", just to do something like that. Here:
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top