egokillo.blogg.se

In this way, we have got matches for the Products Apple and Green Apple for the SalesPerson Howard and for Cherry, Blackberry, and Tomato which are fully matched as the similarity is 100%.Įffects of Changing Number of Matches and Similarity Thresholdĭepending on the selection of this option, we will get the highest number of matches.įor selecting the Number of Matches as 1, Select the FuzzyLookup.Similarity for getting the percentage indication of similarities.įor this step, we have selected the Number of Matches as 1 and the Similarity Threshold as 0.51 and then pressed Go. Now, we have to select the columns on the basis of which we want this comparison, as we want this comparison on the basis of the Product column and the SalesPerson column so these columns are selected in the Left Columns and Right Columns boxes.Īs Output Columns select the January.Product and January.SalesPerson from the January table and,įebruary.Product and Febuary.SalesPerson from the February table and finally, ➤ 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.