Forum Discussion
DavidM330
Mar 10, 2022Copper Contributor
Fuzzy Lookup in Excel giving very low similarity
Hello. Today I've tried the https://www.microsoft.com/en-us/download/details.aspx?id=15011 both in Excel 2016 and Excel 365, and in both cases, very similar strings get a very low similarity (0.001) and with a slightly smaller change they don't get matched at all.
Steps to reproduce:
- Open the example file from the addin folder (Portfolio.xlsx)
- Click the Fuzzy Lookup icon to open the dialog
- Select the Portfolio and SP500_data tables
- Choose "Company" in both left and right tables
- Leave all defaults and click Go to create the comparison table
Expected result: different similarity values as high as 90% (as seen in https://www.mrexcel.com/excel-tips/excel-2020-use-the-fuzzy-lookup-tool-from-microsoft-labs/ article, with the same data).
Result I get: all matches have 0.001 similarity.
Exactly the same has happened with other data I have written as tests. I haven't found any parameter that lets me get different results.
Do you have any idea why this could be happening? Thanks!
No RepliesBe the first to reply