XMATCH
Returns the relative position of an item in an array or range.
| Category | Lookup |
| Syntax | XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
lookup_value | Required | The value to search for. |
lookup_array | Required | The array or range to search. |
match_mode | Optional | 0 (exact), -1 (exact or next smaller), 1 (exact or next larger), 2 (wildcard). Defaults to 0. |
search_mode | Optional | 1 (first-to-last), -1 (last-to-first), 2 (binary asc), -2 (binary desc). Defaults to 1. |
Example
XMATCH(value, range, col)
Auto-generated from the EngCanvas function registry.