XMATCH
Returns the relative position of an item in an array or range of cells.
Lookup & ReferenceLookup & Matching EssentialsModern Excel FunctionsMost Used
What it does
Returns the relative position of an item in an array or range (modern MATCH).
Syntax
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Arguments
lookup_value(value) — Value to find.lookup_array(range) — Range to search.
Examples
Exact match position
Find the position of "HR" in A2:A6.
FORMULA
=XMATCH("HR",A2:A6,0)RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Department |
| 2 | Ops |
| 3 | Sales |
| 4 | HR |
| 5 | IT |
| 6 | Finance |