![compare two lists for matches excel 2016 mac compare two lists for matches excel 2016 mac](https://www.myexcelonline.com/wp-content/uploads/2015/07/Screenshot-2021-02-02-at-2.36.18-PM.png)
This is also where we can select fuzzy matching as an option, check the Use fuzzy matching to perform the merge box.
![compare two lists for matches excel 2016 mac compare two lists for matches excel 2016 mac](https://www.myexcelonline.com/wp-content/uploads/2015/07/Match-Two-Lists-5.jpg)
There are several choice, but we'll stick with the default option to return all items from the first list and only matching items from the second list.
![compare two lists for matches excel 2016 mac compare two lists for matches excel 2016 mac](https://cdn.ablebits.com/_img-blog/compare-excel-files/excel-files-synchronous-scrolling.png)
This is where we'll also find the new fuzzy match feature. This allows us to join data in two tables based on a common field like an ID column, or in our case the Product name column. Power Query has an option to merge tables. Once this is done for both tables, we'll be able to merge (join) the tables in another query.