In this article:

How to Do a Fuzzy Match in Google Sheets (2024 Update)

May 8, 2024

How to Do a Fuzzy Match in Google Sheets

Google Sheets doesn't have a built-in function explicitly designed for fuzzy matching, but you can achieve an approximation using a combination of functions like VLOOKUP or MATCH with wildcards for simple cases, or more complex formulas involving REGEXMATCH for partial text matches. 

However, these methods are limited and might not provide the robustness required for true fuzzy matching.

For more sophisticated fuzzy matching, you can use add-ons designed for this purpose. Here's how you can use an add-on for fuzzy matching:

1. Install the Add-on

Go to Extensions > Add-ons > Get add-ons.

fuzzy match google sheets

Search for a fuzzy matching add-on. Click on it and follow the instructions to install.

fuzzy match in google sheets

2. Using the Add-on

After installation, you will find the add-on under Extensions > Add-ons. Open the add-on and follow its instructions to perform fuzzy matching. 

Below, we have our sample data where we find partial duplicates using the add-on we installed earlier:

do a fuzzy match in google sheets

Simply click "Apply" at the bottom once you have selected your correct value to correct the partial duplicates.

google sheets fuzzy matching

We hope that this article has helped you and given you a better understanding of how to perform a fuzzy match in Google Sheets. If you enjoyed this article, you might also like our articles on how to consolidate data in Google Sheets and how to connect Google sheets to Notion.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->