8/18/2019 Steps to Use Fuzzy Lookup in Excel

1/3

Steps to use Fuzzy Lookup inExcel

1. Open data set in Excel• Data can be in CSV format, or an Excel Workbook

2. Create data table in Excel1. Select rane to !e"ne your !ata table#. $ress to %Ctrl + L] to acti&ate t'e Create (able )izar!, click *+k-. i&e t'e !ata table a name, e.. *D/(/0(/LE

Figure 1: Create data table from selected region

Figure 2: Naming the data table

3. Fuzz !oo"up #heet

1. /!! a ne) s'eet to t'e Workbook#. From t'e Fuzzy Lookup 2ibbon, click t'e Fuzzy Lookup button-. Select *D/(/0(/LE as bot' Left an! 2i't tables to compare

8/18/2019 Steps to Use Fuzzy Lookup in Excel

2/3

3. Select *C0C4S(05/6E for bot' Left an! 2i't columns to matc'7. Click t'e *Con"ure button8. /!9ust t'e *E!it(ransformation('res'ol! &alue to :.;7 for t'e *Default

column con"uration an! click *+k;. 8,-,F/LSE@,JJ@Fill all ro)s

=. /pply con!itional formattin to t'e *Similarity columna. Select *Data ars K ra!ient Fills K 2e! Data ar

8/18/2019 Steps to Use Fuzzy Lookup in Excel

3/3

Final Output