FUZZYMATCH

Namespaced Aliases

FM_FUZZYLOOKUP

Collision-resistant alias for FUZZYLOOKUP.

Syntax

=FM_FUZZYLOOKUP(search_key, lookup_range, result_range, [threshold], [method], [case_sensitive], [return_score])

Parameters

Namesearch_key
Typetext, number, or date
DescriptionValue to find.
Namelookup_range
Typerange
DescriptionCandidate values to search.
Nameresult_range
Typerange
DescriptionValues or rows to return from the same matching position.

Returns

The same matched result as FUZZYLOOKUP.

Example

=FM_FUZZYLOOKUP(A2, Accounts!A:A, Accounts!B:B, 0.82, "token_sort")

Result: West Acme LLC

Notes

FM_FUZZYLOOKUP accepts the same optional arguments as FUZZYLOOKUP.

Use the alias when you want formulas with a family prefix.

    xs