FUZZYMATCH reference

FUZZYMATCH

Find close-enough names, labels, and IDs with formula-first similarity, fuzzy match, and fuzzy lookup functions.

12 custom functions

Jaro-Winkler scoring

Fuzzy VLOOKUP

No external API calls

CRM cleanup

Match misspelled contact and account names without exporting to a separate reconciliation tool.

Find close company names across invoices, payment exports, and source-of-truth vendor tables.

Return the matched key and score alongside lookup results so humans can audit borderline rows.

3 functions

Returns a 0-1 fuzzy similarity score between two values.

Returns the Levenshtein edit distance between two values.

Returns the Jaro-Winkler similarity score between two values.

3 functions

Returns the 1-based position of the closest fuzzy match in a range.

Searches the first column of a table and returns a selected column from the best fuzzy row.

Searches one range fuzzily and returns the matching value or row from a separate result range.

6 functions

Collision-resistant alias for SIMILARITY.

Collision-resistant alias for LEVENSHTEIN.

Collision-resistant alias for JARO_WINKLER.

Collision-resistant alias for FUZZYMATCH.

Collision-resistant alias for FUZZYVLOOKUP.

Collision-resistant alias for FUZZYLOOKUP.