Parameter List
Syntax
FLOOKUP(search_value, search_range,
[type]
, [threshold]
)search_value
Text or cell reference containing the string to match. For example: "ACME LTD" or A2.
search_range
One-dimensional range of candidate strings to search within. For example: B2:B100.
[optional] type
Optional. Matching algorithm selector:
1(default) = Case-insensitive substring matching2= Levenshtein distance matching
[optional] threshold
Optional. Maximum allowed distance (for Levenshtein mode). Prevents poor matches. Example: 2.