MrExcel Publishing
Your One Stop for Excel Tips & Solutions
Microsoft MVP

Excel 2019: Use the Fuzzy Lookup Tool from Microsoft Labs

August 15, 2019 - by Bill Jelen

Excel Use the Fuzzy Lookup Tool from Microsoft Labs. Photo Credit: Dayne Topkin at Unsplash.com

When you use VLOOKUP, HLOOKUP, or INDEX/MATCH, Excel is expecting an exact match. But in real life, data is messy. Several years ago, the research team at Microsoft Labs released a free Fuzzy Lookup add-in. The functionality was never added to Excel, but later showed up in SQL Server. However, the free tool is still available from https://mrx.cl/fuzzylookup

Download and install the add-in. The last step of the install process lets you open the install folder where you will you will find a ReadMe document and a sample Excel file.

Open the sample file. On the Fuzzy Lookup tab, choose Fuzzy Lookup. In the panel that opens, choose the Left Table, the Right Table, and the columns in common.

continue reading »

More Reading

Excel Replace the Comma Style in Book.xltx. Photo Credit: Javier Reyes at Unsplash.com

Excel 2019: Replace Columns of VLOOKUP with a Single MATCH »

August 14, 2019 - by Bill Jelen

VLOOKUP is powerful, but it takes a lot of time to do calculations. Plus, the formula has to be edited in each cell as you copy across.

Excel VLOOKUP to Two Tables. Photo Credit: Andreas Dress at Unsplash.com

Excel 2019: VLOOKUP to Two Tables »

August 12, 2019 - by Bill Jelen

I met a person who had two price lists. The price list for the top 100 products is updated weekly. The price list for the other products is updated twice a year. They needed a logic...

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

Microsoft Excel 2019 VBA and Macros

Microsoft Excel 2019 VBA and Macros »

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

Excel Data Cleansing Straight To The Point

Excel Data Cleansing Straight To The Point »

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »

Hands-on book to learn and master the DAX language!

Excel Dynamic Arrays Straight to the Point

Excel Dynamic Arrays Straight to the Point »

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »

Learn Power BI Dashboarding Techniques by Watching A Pro!

see more products »