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
Step 2: Install the Add-In and restart Excel
Use the instructions on Microsoft's website in the link above.