Fuzzy Lookup

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.

Absolutely, Thanks.

Here is a sample file with 2 pseudo tables. Would like to run a fuzzy lookup in table 2 that looks into table 1 and returns employee ID.

The code I tried didn't seem to work but I know I am not nearly as versed as you gentlemen with this stuff.

Thank you kindly for your time.

Hi wherdzik,

I'd like an attempt to help but the solution I found is more complex that using functions and uses VBA (may need to switch this post to VBA):

Here is the I found website regarding this:

HTML Code: 

You need the function code and add it in a module:
On Table 2 B2:

Please Login or Register  to view this content.

Hope this helps.

Good Lord, I struggled with that vba code and I could not get it to shine. Glen, thank you for your help. Those are wonderful!

Thank you for always willing to help!
Much appreciated again!

thank you for sharing ..i have never realized this can be done in powerquery...I use powerquery quite a but but definitely not to this level but I will keep that in the back of my pocket.
Thanks again.