What then can you do?
Use Microsoft’s Fuzzy Lookup add-in. You can download it here: Microsoft Research’s Fuzzy Lookup
When you are done installing it, you will see it show as a new menu tab in your Excel.
If it’s not showing up in yours, you might need to toggle it off and on in the COM Add-in section of Excel Options.
So how do you use it?
Copy the two records side by side in one sheet in Excel.
Then format each record set as a Table. And you 60% done.
Just launch the Fuzzy Lookup tool and set the fields you want to match. Set the Similarity Threshold.
Select the cell to put the output results and click on Go.
And that’s all! You’ll see it work its magic, saving hours you would have spent doing manual matching.