Skip to content

xmatch

Modern match with full search-mode controls.

v = xmatch(lookup_value, lookup_array, match_mode, search_mode)

Like match but with the same enriched match_mode and search_mode arguments as xlookup — supports wildcards, search direction, and binary search.

xmatch('apple', A1:A100)
  • xlookup — Modern lookup with optional default and search direction.
  • match — Position of a value in a vector.