How to do non exact match in Excel

How to do non exact match in Excel

If you're using one of the latest versions of Microsoft Office (later than Office 2016). You may be able to use the built-in fuzzy logic match feature in PowerQuery. I ended up using this method because with Excel 2016 but this claims to work with some older versions of Excel as well. It only takes a few minutes to test it out so worth a try if you're using an earlier version of Excel.

Step 1: Download the Add-in

Download the add-in located directly from Microsoft's website here. If this link does not work, I've hosted a copy of the Add-In here.

Step 2: Install the Add-In and restart Excel

Use the instructions on Microsoft's website in the link above.

Step 3: Follow the steps in this video

Show Comments