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

[SkywardPalm]

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

(Reference Sheet)

Product Reference Book.xlsx
	A	B
1	Product ID	Product Description
2	00053768032	ALBUMINAR-25 VIAL 25 % 50
3	00053768033	ALBUMINAR-25 VIAL 25 % 100
4	00093005001	ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
5	00093363020	Acyclovir 50 mg/g CREAM
6	00228202750	ALPRAZOLAM TABLET 0.25 MG 500
7	00228202796	ALPRAZOLAM TABLET 0.25 MG 1000
8	00228202950	ALPRAZOLAM TABLET 0.5 MG 500
9	00228202996	ALPRAZOLAM TABLET 0.5 MG 1000
10	00406048301	ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
11	00409193201	ADENOSINE VIAL 3 MG/ML 20
12	00409193202	ADENOSINE VIAL 3 MG/ML 30
13	00536132710	ACETAMINOPHEN 325 MG TAB 1000
14	00703877601	ADENOSINE VIAL 3 MG/ML 20
15	00703877701	ADENOSINE VIAL 3 MG/ML 30
16	00781107705	ALPRAZOLAM TABLET 0.5 MG 500
17	00781107710	ALPRAZOLAM TABLET 0.5 MG 1000
18	00781729685	ALBUTEROL SULF HFA 90 MCG INH
19	00904578961	ACYCLOVIR CAPSULE 200 MG 100
20	00904579061	ACYCLOVIR TABLET 400 MG 100
21	00904672024	ACETAMINOPHEN TABLET 500 MG 24
22	10702018501	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
23	13107005801	ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
24	17478054202	ADENOSINE VIAL 3 MG/ML 2
25	17478054225	ADENOSINE VIAL 3 MG/ML 2
26	17478054420	ADENOSINE VIAL 3 MG/ML 20
27	17478054430	ADENOSINE VIAL 3 MG/ML 30
28	17478095302	ADENOSINE VIAL 3 MG/ML 2
29	23155022701	ACYCLOVIR TABLET 400 MG 100
30	23155022705	ACYCLOVIR TABLET 400 MG 500
31	25021030720	ADENOSINE VIAL 3 MG/ML 20
32	31722077701	ACYCLOVIR TABLET 400 MG 100
33	31722077705	ACYCLOVIR TABLET 400 MG 500
34	31722094901	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
35	31722094905	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
36	31722095001	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
37	31722095101	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
38	31722095105	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
39	31722099601	Hydrocodone Bitartrate and Acetaminophen 5; 325 mg/1; mg/1 ORAL TABLET
40	31722099701	Hydrocodone Bitartrate and Acetaminophen 10; 325 mg/1; mg/1 ORAL TABLET
41	42858010350	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
42	42858013901	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 100HYDROCODONE-ACETAMINOPHEN 7.
43	43386035610	HYDROCODONE-ACETAMINOPHEN TABLET 5MG-325MG 1000
44	43386035801	HYDROCODONE-ACETAMINOPHEN TABLET 10-325MG 100
45	43386035810	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 1000HYDROCODONE-ACETAMINOPHEN 1
46	45802073000	ACETAMINOPHEN 650 MG SUPPOS
47	45802073030	ACETAMINOPHEN SUPP.RECT 650 MG 12
48	45802073032	ACETAMINOPHEN SUPP.RECT 650 MG 50
49	45802073033	ACETAMINOPHEN SUPP.RECT 650 MG 100
50	45802073200	ACETAMINOPHEN 120 MG SUPPOS
51	45802073230	ACETAMINOPHEN SUPP.RECT 120 MG 12
52	45802073233	ACETAMINOPHEN SUPP.RECT 120 MG 100
53	46122031278	ACETAMINOPHEN EXTRA STRENGTH CAPSULE 500MG 100
54	46122042462	ACETAMINOPHEN TABLET 160 MG 24Pain Relief 160 mg/1 TABLET, CHEWABLE
55	46122043078	ACETAMINOPHEN TABLET 325MG 100
56	46122064971	Acetaminophen 500 mg/1 ORAL TABLET, FILM COATED
57	47781022905	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
58	49483034010	ACETAMINOPHEN TABLET 325 MG 1000ACETAMINOPHEN 325 MG TABLET
59	50268040015	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 50
60	50268040115	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 50
61	50268040215	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 50
62	50268064415	OXYCODONE-ACETAMINOPHEN TABLET 5MG-325MG 50
63	50268064615	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 50
64	50268077415	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 50
65	50383033705	Acetaminophen and Codeine Phosphate 120; 12 mg/5mL; mg/5mL ORAL SOLUTION
66	50383033706	Acetaminophen and Codeine Phosphate 120; 12 mg/5mL; mg/5mL ORAL SOLUTION
67	51407014501	ACYCLOVIR TABLET 400 MG 100
68	51672422201	Butalbital, Acetaminophen and Caffeine 50; 300; 40 mg/1; mg/1; mg/1 ORAL C
69	51862017901	BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-325-40 100
70	51991070405	ALPRAZOLAM TABLET 0.25 MG 500
71	53746061701	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
72	53746061710	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 1000
73	54859080916	Liquid Acetaminophen 160 mg/5mL ORAL LIQUID
74	57664053788	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
75	57896010210	ACETAMINOPHEN TABLET 325 MG 1000ACETAMINOPHEN 325 MG TABLET
76	57896020005	ACETAMINOPHEN TABLET 500 MG 50
77	57896020401	ACETAMINOPHEN TABLET 500 MG 100ACETAMINOPHEN 500 MG TABLET
78	57896026801	ACETAMINOPHEN TB 650MGGERI100@
79	58602022124	ACETAMIN OS 160MG/5ML AURO4OZ@
80	59762371903	ALPRAZOLAM TABLET 0.25 MG 500
81	59762371904	ALPRAZOLAM TABLET 0.25 MG 1000
82	59762372003	ALPRAZOLAM TABLET 0.5 MG 500
83	59762372004	ALPRAZOLAM TABLET 0.5 MG 1000
84	60505004206	ACYCLOVIR CAPSULE 200 MG 100
85	60505530601	ACYCLOVIR TABLET 400 MG 100
86	60687040701	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-500 MG 100
87	60687041771	HYDROCODONE-ACETAMINOPHEN SOLUTION 7.5-325/15 15HYDROCODONE-ACETAMINOPHEN 7
88	60687057124	acetaminophen 650mg/20.30ml american health
89	60687057156	ACETAMINOPHEN 325 MG SOL 100X1
90	61442011201	ACYCLOVIR TABLET 400 MG 100
91	61442011205	ACYCLOVIR TABLET 400 MG 500
92	62991100202	ACETAMINOPHEN POWDER 100 % 500
93	63323043400	Acetaminophen 10 mg/mL INTRAVENOUS INJECTION
94	63323065102	ADENOSINE VIAL 3 MG/ML 2
95	63323065120	ADENOSINE VIAL 3 MG/ML 20
96	63323065130	ADENOSINE VIAL 3 MG/ML 30
97	63629214001	Butalbital, Acetaminophen and Caffeine 50; 325; 40 mg/1; mg/1; mg/1 ORAL T
98	63739044001	ACETAMINOPHEN TABLET 325 MG 750
99	63739068210	ACYCLOVIR TABLET 400 MG 100
100	65162011510	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-650 MG 100
101	65162011550	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-650 MG 500
102	65862092201	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
103	65862092205	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 500
104	66689000550	HYDROCODONE-ACETAMINOPHEN SOLUTION 5-217MG/10 10HYDROCODONE-ACETAMINOPHEN 5
105	66689002304	HYDROCODONE-ACETAMINOPHEN SOLUTION 7.5-325/15 120
106	66689005499	ACETAMINOPHEN SOLUTION 160 MG 5
107	66689005699	ACETAMINOPHEN SOLUTION 650 MG 20.3
108	67253090011	ALPRAZOLAM TABLET 0.25 MG 1000
109	67253090050	ALPRAZOLAM TABLET 0.25 MG 500
110	67253090111	ALPRAZOLAM TABLET 0.5 MG 1000
111	67253090150	ALPRAZOLAM TABLET 0.5 MG 500
112	67457085502	ADENOSINE VIAL 3 MG/ML 2
113	67457085730	ADENOSINE VIAL 3 MG/ML 30
114	67457094010	Acetaminophen 1000 mg/100mL INTRAVENOUS INJECTION, SOLUTION
115	68001049500	ACETAMINOPHEN 650 MG ER TAB 100
116	68047072130	BUTALBITAL-ACETAMINOPHEN TABLET 50MG-325MG 30BUTALBITAL-ACETAMINOPHEN 50-32
117	68084010701	ACYCLOVIR CAPSULE 200 MG 100
118	68084010801	ACYCLOVIR TABLET 400 MG 100
119	68084077725	ACETAMINOPHEN ER TABLET ER 650 MG 30
120	68084082501	TRAMADOL HCL-ACETAMINOPHEN TABLET 37.5-325MG 100
121	68084089509	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 80
122	68094003062	Acetaminophen 650 mg/20.3mL SUSPENSION
123	68094058658	CHILDREN'S ACETAMINOPHEN SYRINGE 80MG/2.5ML 2.5
124	68094058758	CHILDREN'S ACETAMINOPHEN SYRINGE 160 MG/5ML 5
125	68094058862	CHILDREN'S ACETAMINOPHEN ORAL SUSP 325/10.15 10.15
126	68382079101	ACYCLOVIR TABLET 400 MG 100
127	68382079105	ACYCLOVIR TABLET 400 MG 500
128	68682030601	BUTALBITAL-ACETAMINOPHEN TABLET 50MG-300MG 100
129	69076014601	ACYCLOVIR CAPSULE 200 MG 100
130	69367020305	BUTALBITAL-ACETAMINOPHEN-CAFFE TABLET 50-325-40 500BUTALBITAL-ACETAMINOPHEN
131	70000003601	Acetaminophen 500 mg/1 TABLET
132	70000006601	Acetaminophen, Aspirin, Caffeine 250; 250; 65 mg/1; mg/1; mg/1 ORAL TABLET
133	70000030901	CHILDREN'S ACETAMINOPHEN TAB CHEW 160MG 24
134	70000031001	CHILDREN'S ACETAMINOPHEN TAB CHEW 160 MG 24
135	70000031201	ACETAMINOPHEN TABLET 500MG 50
136	70000037302	ACETAMINOPHEN TABLET 500 MG 50
137	70000041101	ACETAMINOPHEN PM TABLET 500MG-25MG 24ACETAMINOPHEN PM CAPLET
138	70000041102	ACETAMINOPHEN PM TABLET 500MG-25MG 50ACETAMINOPHEN PM CAPLET
139	70000041103	ACETAMINOPHEN PM TABLET 500MG-25MG 100ACETAMINOPHEN PM CAPLET
140	70000050901	Leader Extra Strength Acetaminophen 500 mg/1 CAPSULE, LIQUID FILLED
141	70010004401	Butalbita,Acetaminophen and Caffeine 50; 300; 40 mg/1; mg/1; mg/1 ORAL CAP
142	70092143546	ACETAMINOPHEN SYRINGE 10 MG/ML 10
143	71205098130	Butalbital, Acetaminophen, Caffeine 50; 325; 40 mg/1; mg/1; mg/1 ORAL TABL
144	71399802701	ACETAMINOPHEN ES 500 MG TAB 100
145	71930001912	HYDROCODONE-ACETAMINOPHEN TABLET 5MG/325MG 100
146	71930002112	HYDROCODONE-ACETAMINOPHEN TABLET 10-325 100
147	71930002152	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500HYDROCODONE-ACETAMINOPHEN 10
148	71930004612	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
149	71930005552	ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 500
150	75834012401	ACYCLOVIR CAPSULE 200 MG 100
151	81033000250	ACETAMIN160MG/5ML UD CUPKES50@
152	96295013134	acetaminophen (TYLENOL) 650 MG TbSR 50 EA
153	00067820001	Acetaminophen, Dextromethorphan HBr, Phenylephrine HCl, Diphenhydramine HCl
154	00067820304	Acetaminophen, Aspirin (NSAID), and Caffeine
155	00093035010	ACETAMINOPHEN-CODEINE TABLET 300MG-60MG 1000
156	00113039726	acetaminophen
157	00113043778	Acetaminophen, Diphenhydramine HCl
158	00113076334	Acetaminophen, Dextromethorphan HBr, Doxylamine Succinate, Phenylephrine HCl
159	00113090326	Acetaminophen, Chlorpheniramine Maleate, Dextromethorphan HBr, Phenylephrine HCl
160	00113700078	Basic Care acetaminophen 500 mg/1 TABLET, FILM COATED
161	00113700079	BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET, FILM COATED
162	00113743778	basic care acetaminophen PM 500; 25 mg/1; mg/1 TABLET, FILM COATED
163	00113748482	basic care acetaminophen 500 mg/1 TABLET
164	00113748483	BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET
165	00113748490	BASIC CARE ACETAMINOPHEN 500mg/1 ORAL TABLET
166	00113754479	Basic Care Acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
167	00121078104	Childrens Acetaminophen
168	00121093900	Childrens Acetaminophen 160 mg/5mL ORAL SUSPENSION
169	00121094100	Acetaminophen Oral Suspension 160mg/5mL UD CUP
170	00121094194	Acetaminophen Oral Suspension 160mg/5mL UD CUP
171	00121094600	Childrens Acetaminophen Oral Suspension 160mg/5mL UD Cup
172	00121094630	Childrens Acetaminophen Oral Suspension 160mg/5mL UD Cup
173	00121187800	Childrens Acetaminophen 360 mg/10mL ORAL SUSPENSION
174	00121188200	Acetaminophen 325mg/10.15mL Suspension UD Cup
175	00121188294	Acetaminophen 325mg/10.15mL Suspension UD Cup
176	00121282394	ACETAMINOPHEN 650 MG/20.3 ML UD CUP
177	00135701101	acetaminophen
178	00135701102	acetaminophen
179	00135701104	acetaminophen
180	00135702101	acetaminophen and diphenhydramine HCl
181	00245041001	Hydrocodone Bitartrate and Acetaminophen 5; 325 mg/1; mg/1 TABLET
182	00245041011	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
183	00245041050	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
184	00245041101	Hydrocodone Bitartrate and Acetaminophen 7.5; 325 mg/1; mg/1 TABLET
185	00245041111	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
186	00245041150	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
187	00245041201	Hydrocodone Bitartrate and Acetaminophen 10; 325 mg/1; mg/1 TABLET
188	00245041211	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
189	00245041250	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
190	00264405080	ACETAMINOPHEN 10MG/ML 24X50 IP
191	00280002202	chlorpheniramine maleate, acetaminophen, phenylephrine hydrochloride, dextromethorphan hydrobromide
192	00280005501	chlorpheniramine maleate, dextromethorphan hydrobromide, acetaminophen, phenylephrine hydrochloride
193	00363033422	Acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
194	00363033455	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
195	00363033602	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
196	00363033624	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
197	00363034008	Acetaminophen 650 mg/1 TABLET, EXTENDED RELEASE
198	00363697302	Extra Strength Acetaminophen 500 mg/1 ORAL TABLET
199	00363979710	Acetaminophen 500 mg/5001 ORAL TABLET
200	00363999175	Acetaminophen Diphenhydramine HCl 500; 25 mg/1; mg/1 ORAL TABLET
201	00363999210	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
202	00363999220	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
203	00363999224	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
204	00363999315	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
205	00363999321	Acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEASE
206	00404071413	Henry Schein Acetaminophen 325 mg/1 TABLET, FILM COATED
207	00404071499	HENRY SCHEIN ACETAMINOPHEN 325mg/1 ORAL TABLET, FILM COATED
208	00404071613	Henry Schein Acetaminophen 500 mg/1 TABLET, FILM COATED
209	00406012310	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 1000
210	00406012312	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 120
211	00406012320	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
212	00406012323	HYDROCODONE-ACETAMINOPHEN 5-325 MG TABLET
213	00406012330	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 30HYDROCODONE-ACETAMINOPHEN 5-3
214	00406012360	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
215	00406012390	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
216	00406012412	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 120
217	00406012420	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
218	00406012423	HYDROCODONE-ACETAMINOPHEN 7.5-325 MG TABLET
219	00406012430	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
220	00406012460	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
221	00406012490	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
222	00406012512	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 120
223	00406012520	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
224	00406012523	HYDROCODONE-ACETAMINOPHEN 10-325 MG TABLET
225	00406012530	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
226	00406012560	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 60HYDROCODONE-ACETAMINOPHEN 10-
227	00406012590	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
228	00406037601	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 100
229	00406037605	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500
230	00406037623	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
231	00406037662	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
232	00406037705	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500
233	00406037723	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
234	00406037762	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
235	00406037805	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500
236	00406037823	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
237	00406037862	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
238	00406048420	ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 20
239	00406048450	ACETAMINOPHEN-CODEINE TABLET 300MG-30MG 50
240	00406051291	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 5000
241	00406052205	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325MG 500
242	00527164601	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 100HYDROCODONE-ACETAMINOPHEN 5-
243	00527164605	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500HYDROCODONE-ACETAMINOPHEN 5-
244	00527164701	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 100HYDROCODONE-ACETAMINOPHEN 7.
245	00527164705	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500HYDROCODONE-ACETAMINOPHEN 7.
246	00527164801	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 100HYDROCODONE-ACETAMINOPHEN 10
247	00527164805	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500HYDROCODONE-ACETAMINOPHEN 10
248	00527164905	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500HYDROCODONE-ACETAMINOPHEN 5-
249	00527165005	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 500HYDROCODONE-ACETAMINOPHEN 7.
250	00527165105	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500HYDROCODONE-ACETAMINOPHEN 10
251	00527166901	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 100OXYCODONE-ACETAMINOPHEN 5-325
252	00527166905	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
253	00527167101	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
254	00527167105	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
255	00527409437	BUTALBITAL, ACETAMINOPHEN, AND CAFFEINE 50; 325; 40mg/1; mg/1; mg/1 ORAL CA
256	00536129229	Acetaminophen 500 mg/1 ORAL TABLET
257	00536132706	ACETAMINOPHEN 325 MG TAB 50
258	00591264005	BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-300-40 500
259	00603233721	ACETAMINOPHEN-CODEINE TABLET 300MG-15MG 100
260	00603389032	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 1000
261	00615759039	Acetaminophen Extended Release 650 mg/1 TABLET
262	00615810239	Acetaminophen and Codeine Phosphate 300; 30 mg/1; mg/1 TABLET
263	00615825030	Acetaminophen 500 mg/1 ORAL TABLET
264	00615825039	Acetaminophen 500 mg/1 TABLET
265	00615827930	Acetaminophen 325 mg/1 ORAL TABLET
266	00615827939	Acetaminophen 325 mg/1 TABLET
267	00615828167	Acetaminophen 325 mg/1 TABLET
268	00615839730	ACETAMINOPHEN
269	00615839739	ACETAMINOPHEN
270	00615839867	ACETAMINOPHEN
271	00615840439	Acetaminophen
272	00641611310	ADENOSINE VIAL 3 MG/ML 2
273	00781106105	ALPRAZOLAM TABLET 0.25 MG 500
274	00781106110	ALPRAZOLAM TABLET 0.25 MG 1000
275	00781927495	ACETAMIN 10MG/ML 10X100ML PPX SDV
276	00924013100	Acetaminophen, Aspirin, Caffeine
277	00924013101	Acetaminophen, Aspirin, Caffeine
278	10702018410	OXYCODONE AND ACETAMINOPHEN 2.5; 325mg/1; mg/1 ORAL TABLET
279	10702018450	OXYCODONE AND ACETAMINOPHEN 2.5; 325mg/1; mg/1 ORAL TABLET
280	10702018510	OXYCODONE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
281	10702018550	OXYCODONE-ACETAMINOPHEN TABLET 5 MG-325MG 500OXYCODONE-ACETAMINOPHEN 5-325
282	10702018601	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 100OXYCODONE-ACETAMINOPHEN 7.5-32
283	10702018610	OXYCODONE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
284	10702018650	OXYCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 500OXYCODONE-ACETAMINOPHEN 7.5-32
285	10702018701	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 100OXYCODONE-ACETAMINOPHEN 10-325
286	10702018710	OXYCODONE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
287	10702018750	OXYCODONE-ACETAMINOPHEN TABLET 10MG-325MG 500OXYCODONE-ACETAMINOPHEN 10-325
288	10702018903	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 325mg/1; mg/1 ORAL TABLET
289	10702019003	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 325mg/1; mg/1 ORAL TABLET
290	10702019010	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-325 MG 1000HYDROCODONE-ACETAMINOPHEN 7
291	10702019103	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 325mg/1; mg/1 ORAL TABLET
292	10702019110	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-325MG 1000HYDROCODONE-ACETAMINOPHEN 1
293	10702019203	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
294	10702019210	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 5; 300mg/1; mg/1 ORAL TABLET
295	10702019250	HYDROCODONE-ACETAMINOPHEN TABLET 5 MG-300MG 500HYDROCODONE-ACETAMINOPHEN 5-
296	10702019303	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
297	10702019310	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 7.5; 300mg/1; mg/1 ORAL TABLET
298	10702019350	HYDROCODONE-ACETAMINOPHEN TABLET 7.5-300 MG 500HYDROCODONE-ACETAMINOPHEN 7.
299	10702019403	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
300	10702019410	HYDROCODONE BITARTRATE AND ACETAMINOPHEN 10; 300mg/1; mg/1 ORAL TABLET
301	10702019450	HYDROCODONE-ACETAMINOPHEN TABLET 10MG-300MG 500HYDROCODONE-ACETAMINOPHEN 10
302	10702023850	OXYCODONE AND ACETAMINOPHEN 5; 325mg/5mL; mg/5mL ORAL SOLUTION
303	10702034301	BENZHYDROCODONE-ACETAMINOPHEN TABLET 4.08-325MG 100
304	10702034401	BENZHYDROCODONE-ACETAMINOPHEN TABLET 6.12-325MG 100BENZHYDROCODONE-ACETAMIN
305	10702034501	BENZHYDROCODONE-ACETAMINOPHEN TABLET 8.16-325MG 100BENZHYDROCODONE-ACETAMIN
306	11534018704	BUTALBITAL-ACETAMINOPHEN-CAFFE CAPSULE 50-300-40 500
307	11673010526	ACETAMINOPHEN ORAL SUSP 160 MG/5ML 118
308	11673013316	ACETAMINOPHEN ORAL SUSP 160 MG/5ML 59
309	11673013326	up and up acetaminophen infants 160 mg/5mL ORAL SUSPENSION
310	11673014808	Acetaminophen 500 mg/1 TABLET
311	11673034201	ACETAMINOPHEN 500 mg/1 TABLET, FILM COATED
312	11673034226	ACETAMINOPHEN 500 mg/1 ORAL TABLET, FILM COATED
313	11673034242	ACETAMINOPHEN 500 mg/1 ORAL TABLET, FILM COATED
314	11673043747	up and up acetaminophen pm 500; 25 mg/1; mg/1 TABLET, FILM COATED
315	11673043762	up and up acetaminophen pm extra strength 500; 25 mg/1; mg/1 ORAL TABLET, F
316	11673048471	ACETAMINOPHEN TABLET 500 MG 50
317	11673048483	ACETAMINOPHEN TABLET 500 MG 225
318	11673048490	up and up acetaminophen extra strength 500 mg/1 ORAL TABLET
319	11673051915	ACETAMINOPHEN TABLET 500 MG 50
320	11673051920	ACETAMINOPHEN TABLET 500 MG 225
321	11673061862	Up and Up acetaminophen 650 mg/1 TABLET, FILM COATED, EXTENDED RELEASE
322	11673061878	Up and Up acetaminophen 650 mg/1 ORAL TABLET, FILM COATED, EXTENDED RELEAS
323	11673083801	acetaminophen 500 mg/1 ORAL TABLET, COATED
324	11673083805	acetaminophen 500 mg/1 ORAL TABLET, COATED
325	11673083826	acetaminophen 500 mg/1 ORAL TABLET, COATED
326	11673083850	acetaminophen 500 mg/1 ORAL TABLET, COATED
Sheet1

 

[SkywardPalm]

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.

 

[Akuini]

@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.

 

[SkywardPalm]

@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!

 

[SkywardPalm]

Also posted on OzGrid

 

[Akuini]

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:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com