I used to have an add in called Fuzzy Lookup from Microsoft and our IT department cant seem to get it installed on my 0365 excel. It is really useful so looking for alternatives. I did find some code online but it still doesn't seem to work right.

I have two tables and I want to find the closest match so I can perform a vlookup to that table. So example one table has the name James, Maynard and the other table has James MD, Maynard. Is there a way to replicate the fuzzy lookup somehow?


Thank you.