xmatch
Modern match with full search-mode controls.
Syntax
Section titled “Syntax”v = xmatch(lookup_value, lookup_array, match_mode, search_mode)Description
Section titled “Description”Like match but with the same enriched match_mode and search_mode arguments as xlookup — supports wildcards, search direction, and binary search.
Example
Section titled “Example”xmatch('apple', A1:A100)