Google Sheets has no built-in fuzzy match. VLOOKUP, MATCH and XLOOKUP only find text that is identical, so "Inytech" will never find "Initech", and "ACME Pty. Ltd" will never find "Acme Pty Ltd". This
Google Sheets how-tos: fuzzy matching, duplicates and lookups. Tested formulas you can copy.
Snakbacks builds small, fast Google Sheets tools and writes tested how-to guides at https://www.snakbacks.com
Markdown supported · ⌘↵ to post
No responses yet.