Courses
MATCH Function
Return value
Returns the array position index of the first value in the array that matches the lookup value.
Syntax
= MATCH(lookup_value; lookup_array; [match_type])
Arguments
| Argument | Description | Options | Description |
|---|---|---|---|
| lookup_value | The value to look for. | ||
| lookup_array | The array to look in. | ||
| [match_type] | [Optional]: Set it to zero (0) as standard. | 1 | Less than |
| 0 | Exact match | ||
| -1 | Greater than |
Remarks
Tip: MATCH nested within VLOOKUP
MATCH is preferably used as a nested function within VLOOKUP to make VLOOKUP more dynamic.