Namespaced Aliases
FM_FUZZYVLOOKUP
Collision-resistant alias for FUZZYVLOOKUP.
Syntax
=FM_FUZZYVLOOKUP(search_key, table_range, result_index, [threshold], [method], [case_sensitive], [return_score])Parameters
NameTypeDescription
Name
search_keyTypetext, number, or date
DescriptionValue to find.
Name
table_rangeTyperange
DescriptionTable whose first column contains candidate values.
Name
result_indexTypenumber
Description1-based column index to return from table_range.
Returns
The same matched result as FUZZYVLOOKUP.
Example
=FM_FUZZYVLOOKUP(A2, Accounts!A:D, 4, 0.82)Result: C-1042
Notes
FM_FUZZYVLOOKUP accepts the same optional arguments as FUZZYVLOOKUP.
Use the alias when you want formulas with a family prefix.