MATCH
Searches for a specified item in a range of cells, and then returns the relative position of that item in the range
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Parameters
- lookup_value: Required. The value that you want to match in lookup_array
- lookup_array: Required. The range of cells being searched
- match_type: Optional. 1=less than or equal (default, sorted ascending), 0=exact match, -1=greater than or equal (sorted descending)
Example
=MATCH("Sunday", A1:A7, 0)