Forum Discussion

reeef175's avatar
reeef175
Copper Contributor
Aug 01, 2022

Fuzzy Lookup add on in Excel not matching results as expected

Hi,

I have various addresses I'm matching with fuzzy lookup in excel.

To the eye some seem pretty similar but fuzzy lookup is returning a 0 similarity score. I've removed all spaces (including trailing) so this shouldn't impact it.

An example is this:

address 1: 700AndersonHillRdPurchase10577-1444

address 2: 700AndersonHillRoadPurchase10577-1401

I've set the threshold to 0.

Is it a bug?

excel

1 Reply

Sort By
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Aug 02, 2022

    Hi reeef175 

     

    The Fuzzy Lookup Add-In and Get & Transform (aka Power Query) use the same algorithm. With PQ and  Threshold = 0:

     

     

    In the Welcome to your Excel discussion space! post you're kindly asked to provide a few information like your version of Excel...

    Without knowing the version you run not sure you can take the Power Query route. So, please download the attached file > Open it > Go to the FuzzyMatch sheet > Right-click on the green table > Refresh

     

    If you don't get an error this means your version of Excel has Power Query function Table.FuzzyNestedJoin ==> A possible alternative for you

Resources