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. 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.