Get the relative position of a specified search key in a one-dimensional range of cells.
The value to search for. For example: "Super" or 123.
The one-dimensional range of cells or JSON data in which to search for the
search_key. For example:
The way to search. For example
0. By default set to
1. For more information, click on
The way to search.
1when the range is sorted in ascending order and you want the position of the largest value that is less than or equal to the
0when you want the the first exact match in ascending order.
-1when the range is sorted in descending order and you want the smallest value that is greater than or equal to the
If you use
-1 as the
search_type and the ranges are not properly ordered, the outcome can be unpredictable.