Fuzzy Lookup skipping matches

Sorna2020

New Member
Joined
Jun 10, 2016
Messages
6
I have an email list of customers and a list of companies we want to exclude. The email list has almost 8,000 entries so it's an overwhelming project to do manually. I run fuzzy lookup and it is skipping some obvious (to me) matches but matching others that have a similar structure/complexity (Threshold 85). I have double-checked spelling, spaces, etc. Below is a rough example of my results. If I decrease the Similarity Threshold (70), it matches the missing ones but also matches thousands of additional customers.

Table 1Table 2Fuzzy Lookup Similarity
Bayshore HealthBayshore Health1.0000
Bayshore Health- Main campusAshland Hospital0.0000
Bayshore Health- Boca Raton 94th Street0.0000Why No match!?!?
Bayshore Health- SW (FKA Atlantic Imaging)0.0000Why No match!?!?
Bayshore Health- NW (FKA Radiology NW)0.0000Why No match!?!?
Bayshore Health- West0.0000Why No match!?!?
Bayshore Health- East0.0000Why No match!?!?
Bayshore Health- South0.0000Why No match!?!?
Bayshore Health- North0.0000Why No match!?!?
Bayshore HealthCare0.0000Why No match!?!?
Ashland Hospital East0.9800
Oregon Ashland Hospital Emergency Room0.9200
George Welch Family Ashland Hosp0.9100
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
for your example set threshold to 0.09
Column1Column1Similarity
Bayshore HealthBayshore Health1.0000
Bayshore Health- Main campusBayshore Health0.8333
Bayshore Health- Boca Raton 94th StreetBayshore Health0.8182
Bayshore Health- SW (FKA Atlantic Imaging)Bayshore Health0.8182
Bayshore Health- NW (FKA Radiology NW)Bayshore Health0.8182
Bayshore Health- WestBayshore Health0.8571
Bayshore Health- EastBayshore Health0.8571
Bayshore Health- SouthBayshore Health0.8571
Bayshore Health- NorthBayshore Health0.8571
Bayshore HealthCareBayshore Health0.4286
Ashland Hospital EastAshland Hospital0.8571
Oregon Ashland Hospital Emergency RoomAshland Hospital0.8235
George Welch Family Ashland Hosp0.0000
 

Watch MrExcel Video

Forum statistics

Threads
1,127,768
Messages
5,626,758
Members
416,202
Latest member
donya ba

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
Top