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:
Go to Extensions > Add-ons > Get add-ons.
Search for a fuzzy matching add-on. Click on it and follow the instructions to install.
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:
Simply click "Apply" at the bottom once you have selected your correct value to correct the partial duplicates.
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.
