Excel 2024: Use Fuzzy Match in Power Query


November 18, 2024 - by

Excel 2024: Use Fuzzy Match in Power Query

There's a research and development team at Microsoft known as Microsoft Labs. Almost 10 years ago, it invented a free Fuzzy Match add-in for Excel. A fuzzy matching algorithm looks for words that share a percentage of characters in common.

The figure below shows two data sets that need to be matched. Columns A and B contain the list of employees. Columns D and E contain the names of the employees who filled out a required form. You need to identify the people who haven't yet returned the form. Unfortunately, a VLOOKUP or XLOOKUP won't work since column A uses a 'last name, first name' format while column D contains a nickname and last name. These two data sets can be matched using the Fuzzy Match tool that's now built into Windows versions of Microsoft 365.

continue reading »

More Reading


Excel 2024: Clean Data with Power Query

Excel 2024: Clean Data with Power Query »

November 14, 2024 - by Bill Jelen


Power Query is built in to Windows versions of Office 365, Excel 2016, Excel 2019 and is available as a free download in Windows versions of Excel 2010 and Excel 2013. The tool is designed to extract, transform, and load data into Excel from a variety of sources.

Excel 2024: Improve Your Macro Recording

Excel 2024: Improve Your Macro Recording »

November 11, 2024 - by Bill Jelen


I loved the 1985 version of the Macro Recorder in Lotus 1-2-3. The code was hard to understand, but it worked. There are some defaults in the Excel Macro Recorder that cause misery for anyone trying to record macros. Here are three tips to make the macro experience possibly better.

Excel 2024: Interpolate between a starting and ending number

Excel 2024: Interpolate between a starting and ending number »

November 7, 2024 - by Bill Jelen


How to interpolate between a starting and ending number.

read more articles »

Featured Products


Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.


MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.


see more products »