MATCH
Looks up values in a reference or array.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
What it does
Returns the relative position of a value within a range.
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Arguments
lookup_value(value) — Value to find.lookup_array(range) — One-dimensional range to search.
Examples
Find position
Find the position of 30 in A2:A6.
FORMULA
=MATCH(30,A2:A6,0)
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Value |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
| 6 | 50 |