Google Workspace Marketplace
Fuzzy VLOOKUP and XLOOKUP for Google Sheets™. Match messy names to a clean list despite typos, case, punctuation or word order. Adds FUZZYMATCH, FUZZYLOOKUP, FUZZYSCORE. Free.
By:
Listing updated:November 19, 2026
Works with:
No reviews
No users
Overview
Fuzzy Match adds fuzzy VLOOKUP to Google Sheets™. Three formulas match text the way a person would, forgiving typos, capitalisation, punctuation and word order, so you can fuzzy match two lists without helper columns. Free, runs inside your sheet, works on whole columns with one formula.

USE IT TO
• Match customer or company names across two spreadsheets
• Do a fuzzy lookup that returns an ID, price or email from the closest row
• Clean up misspelled names against a master list
• Reconcile lists exported from different systems

THE FORMULAS
• =FUZZYMATCH(A2:A100, Customers!A2:A, 0.8): the closest value from a clean list, for every row at once.
• =FUZZYLOOKUP(A2:A100, Customers!A2:A, Customers!C2:C, 0.8): like XLOOKUP, but fuzzy. Finds the closest row and returns any column from it (an ID, price, email…).
• =FUZZYSCORE(A2, B2): a similarity score from 0 (different) to 1 (same), so you can check or sort matches.

WHAT IT CATCHES
• Typos: "Inytech" → Initech
• Word order: "Corp Umbrella" → Umbrella Corp
• Case and punctuation: "ACME Pty. Ltd" → Acme Pty Ltd
• Accents and symbols are ignored.

NO FALSE GUESSES
Set a threshold between 0 and 1. If nothing is close enough, the cell stays blank instead of guessing wrong. Use 0.9 for strict matching, 0.7 to catch more.

FAST
Pass a whole column and one formula fills it. Exact matches are found instantly, and very different lengths are skipped, so thousands of rows take seconds.

PRIVATE
Everything runs inside your spreadsheet. The add-on can only access the sheet you use it in, and your data never leaves Google Sheets™.

GET STARTED
Extensions > Fuzzy Match > Insert example sheet shows all three formulas on sample data. "How to use" adds a short guide tab.

Questions or requests: info@snakbacks.com

PRO (OPTIONAL, US$19 ONE-TIME)
FUZZYMATCH, FUZZYLOOKUP and FUZZYSCORE stay free, with no limits. Snakbacks Pro adds:
• Fuzzy join: select the key column, then Extensions > Fuzzy Match > Fuzzy join selected columns (Pro). Matched columns from another sheet are written to a new sheet with a match score. Your data is not changed.
• FUZZYMATCHN: the top candidate matches for each value, with scores.
One payment, no subscription. Buy a key at https://snakback.gumroad.com/l/snakbacks-pro, then use Extensions > Fuzzy Match > Enter Pro key and Activate Pro. Pro also runs only inside your spreadsheet and sends no data anywhere.

Google Sheets™ is a trademark of Google LLC.
Additional information
PricingFree of charge with paid features
Developer
Support
Privacy policy
Terms of service
Fuzzy Match: Fuzzy VLOOKUP for Google Sheets™ will ask for the permissions shown below. Learn more
Fuzzy Match: Fuzzy VLOOKUP for Google Sheets™ will need access to your Google account
This will allow Fuzzy Match: Fuzzy VLOOKUP for Google Sheets™ to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu