XMATCH
Description
Searches for a specified item in the list (one-dimensional array) that you specify, and
returns the item's index (position). XMATCH does an exact match search by default. You can
use this function to match logical values, numeric values, or text strings. This function is
intended for use with unconstrained arrays. To submit the formula, use the unconstrained
keyboard shortcut Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac). For syntax
details, see the Function Reference in the User Guide (Help > User Guide)
Syntax
XMATCH(
lookup_value
,
lookup_array
, [
match_mode
], [
search_mode
])
- lookup_value: The lookup value.
- lookup_array: The array to search.
- match_mode: A number that specifies the type of match.
- search_mode: A number that specifies the search mode to use.
Notes
- XMATCH isn't case-sensitive by default (using a match_mode of 0). You can use XMATCH for a case-sensitive exact match search only if the array is sorted.
Related Functions
MATCH
MATCHEXACT