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.