➤ Choose the Left Table as January and the Right Table as February. ➤ Select the cell where you want your output comparison table. Now, you will get a Fuzzy Lookup portion on the right pane. ➤ Go to Fuzzy Lookup Tab > Fuzzy Lookup Option. Step-02: Creating Fuzzy Lookup with Fuzzy Lookup Excel Add-In Similarly, rename the Sales Record of February table as February. ➤ Select the table for Sales Record of January and then go to Table Design Tab > rename the Table Name as January. Prior to using the Fuzzy Lookup option we have to convert the following two data ranges into two different tables.įollowing the article “How to Make a Table in Excel” we have converted the ranges into these tables.
Using Fuzzy Lookup Add-In Step-01: Creation of Two Tables for Fuzzy Lookup Excel We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.ġ. In this article, we will try to show the steps of using the Fuzzy Lookup feature of Excel along with the fuzzy matching option of Power Query to indicate the partial matching of two data tables. Here, we can see that we have a new tab named Fuzzy Lookup which has the Fuzzy Lookup Option. After the completion of installation, when you open your Excel workbook then this feature will be added automatically.
0 kommentar(er)
