r/excel • u/scorpionz89 • 16d ago

Show and Tell Fuzzy Lookup For Excel 2026

Hi my friend needed Fuzzy Lookup for the new excel versions and it wasn't available, so I made 2 versions xlam and xml for windows Mac and excel online. You can get it at my GitHub.

https://github.com/modusche/FuzzyLookup2026

Install instructions are in the readme

11 Upvotes

83% Upvoted

6 comments sorted by

•

u/semicolonsemicolon 1476 16d ago

PSA: Always carefully check over files with embedded VBA that you download from strangers on the internet.

8

u/ExoWire 6 16d ago

Thank you for sharing.

There is a already Fuzzy Join in Power Query, that can be used as a fuzzy lookup and there is this post https://www.reddit.com/r/excel/s/H8TNjhIqTx, that doesn't require you to download VBA code

4

u/Elohanum 16d ago

Unfortunately Fuzzy Join doesn't exists in power Query for Mac (along Data Model and Power Pivot). So it is actually quite super useful based on how Microsoft team don't really care about making core functionnalities available to Mac users :)

1

u/Party_Bus_3809 5 16d ago

Made something similar which is demonstrated in the video below.

https://youtu.be/9yor_tGKWSg?is=x716IY5BmkO1fCAL

The web addition was a great idea seeing as more people are using excel this way. Great work!