Parameter List
Syntax
MATCH(search_key, range,
[search_type]
)search_key
The value to search for. For example: "Super" or 123.
range
The one-dimensional range of cells or JSON data in which to search for the search_key. For example: A1:A6.
[optional] search_type
The way to search. For example 0. By default set to 1. For more information, click here.
More details
The way to search.
Use
1when the range is sorted in ascending order and you want the position of the largest value that is less than or equal to thesearch_key.Use
0when you want the the first exact match in ascending order.Use
-1when the range is sorted in descending order and you want the smallest value that is greater than or equal to thesearch_key.
If you use 1 or -1 as the search_type and the ranges are not properly ordered, the outcome can be unpredictable.
Examples
