So if you’ve retrieved data from traditional tables, convert them to structured before you start comparing. This Excel add-in compares data in structured tables. If you’ve done everything right, a new ribbon wil appear that contains only one option will appear – Fuzzy Lookup! In the menu below, select the COM Add-Ins option, and then in the window that appears, select the option to activate. We do this by clicking on the File tab, and then selecting Options/ Add-Ins. Download is done on this link, and after you install, should add it to Excel. To use this plugin you need to first download and install it. Fuzzy Lookup allows you to compare the column based on the similarity and display the corresponding results in the new table.
Why does this serve for? For example, in practice, it often happens that, when entering a name and surname, an error occurs or there is no one-way entry. Fuzzy Lookup is an Excel add-in created by a Microsoft development team, and can be used for advanced search and comparison of column values in tables.
