LibreOffice 26.2 Help
Searches for a value in a one-dimensional array and returns the relative position of the item.
XMATCH outperforms function MATCH as it allows searches according to the search mode.
XMATCH(Search criterion; Search Array [; Match Mode [; Search Mode ] ] )
Search criterion: The value of any type to search for in Search Array.
Search Array: is the reference of the array or range to search.
Match Mode: (optional) specifies the match type. Values can be:
0: exact match (default). If Search criterion value is not found, then return the #N/A error.
-1: attempt exact match. If Search criterion value is not found, then return the next smaller item.
1: attempt exact match. If Search criterion value is not found, then return the next larger item.
2: a wildcard match where characters *, ?, and ~ have special meanings.
3: a regular expression match.