Fuzzy Lookup skipping matches

S

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
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
sandy666

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
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
 
You must log in or register to reply here.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,624
Messages
5,838,423
Members
430,546
Latest member
CometOz

Share this page

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