Microsoft Fuzzy Lookup Add-In for Excel tutorial

**kukur99** · 06-15-2012, 12:37 PM

Do any of you have experience using the following Add-In from Microsoft?
http://www.microsoft.com/en-ca/downl....aspx?id=15011
Any help will be appreicated.
Similar thread:
http://www.excelforum.com/excel-gene...zy-lookup.html

**abousetta** · 06-16-2012, 03:34 AM

I toyed with it, but didn't really like it. What is your problem and how can we help.

**kukur99** · 06-16-2012, 08:15 AM

Thanks abousetta for your reply.
I have been using the sample workbook file included in the ZIP file from Microsoft (workbook file name: Portfolio.xls).
But having a hard time to understand what or how it is doing?
Thanks in advance for your suggestion and steps.

**abousetta** · 06-16-2012, 09:35 AM

The whole concept of fuzzy lookup is to find the 'closest' match. The idea is to circumvent problems like typing errors, conversion of words like street and st., etc. For you to use the add-in you need Excel 2010 and two distinct tables. It can't match within the same table.

Hope this helps.