FUZZYMATCH

Namespaced Aliases

FM_FUZZYMATCH

Collision-resistant alias for FUZZYMATCH.

Syntax

=FM_FUZZYMATCH(search_key, lookup_range, [threshold], [method], [case_sensitive])

Parameters

Namesearch_key
Typetext, number, or date
DescriptionValue to find.
Namelookup_range
Typerange
DescriptionCandidate values to search.

Returns

The same 1-based match position as FUZZYMATCH.

Example

=FM_FUZZYMATCH("Jilian", A2:A20, 0.9)

Result: 2

Notes

FM_FUZZYMATCH accepts the same optional arguments as FUZZYMATCH.

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

    xs