Microsoft "Fuzzy Lookup" results

schatham

New Member
Joined
May 28, 2003
Messages
42
Using Excel 2010, and the Microsoft "Fuzzy Lookup" add in to compare a column out of 2 worksheets. First worksheet has around 48,000 rows (x 3 columns), second worksheet has around 23,000 rows (x 5 columns). The "Fuzzy Lookup" is comparing one column from each & returning a similarity between the two.


The fuzzy lookup appears to run without a problem, and the results - in most cases - appear to be correct. For example:

W2-NK22/16 in one worksheet shows to have a 0.97 similarity to W2NK2216.

But not in all cases. Some that I expected to have some degree of similarity, instead have 0.000 returned by the Add-In. For example:

761689700000 should have some degree of similarity to:
761689700000EN4239

but the Fuzzy Lookup add in returns 0.000 for it. Both fields are formatted as text.

I have similarity threshold set to 0.48, which should return matches. The only other Fuzzy Lookup settings I have changed were in Configure --> Global -- UseApproximateIndexing. I have set it to both False and True which have had no impact.

I have hundreds of examples like the one above that show 0.000 similarity, but appear to be very similar.

Any ideas or suggestions as to what the issue might be & how best to resolve it?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,729
Messages
5,524,488
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top