MATCH
Returns the relative position of a value within a range.
| Category | Lookup |
| Syntax | MATCH(lookup_value, lookup_array, [match_type]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
lookup_value | Required | The value to match in the lookup array. |
lookup_array | Required | The range of cells to search. |
match_type | Optional | 1 (default) for largest value ≤ lookup_value (sorted ascending), 0 for exact match, -1 for smallest value ≥ lookup_value (sorted descending). |
Example
MATCH(value, range, col)
Auto-generated from the EngCanvas function registry.