Functions
XMATCH
Modern MATCH function with match and search mode options
Try it
When to use it
When should I use XMATCH instead of MATCH?
Use XMATCH when you need advanced match modes (exact, approximate, wildcard, or regular-expression) or reverse/binary search order — it is the modern replacement for MATCH with greater flexibility.
Used in
Syntax
XMATCH(search_key, lookup_array, [match_mode], [search_mode])