Search for a search key in the first column of a range and returns the value of a specified cell in the row corresponding to the selected column.
The two-dimensional range or JSON data to consider for the search. The first column must include the
search_key. For example:
The value to search for in a row, e.g. "Super", 123,
A2, or "Benf*".
The value to search for in a column/header, e.g. "Telephone",
A1, or "Addr*". By default, the function uses the first column.
The way to search. The function accepts values for both axes (column and row). For example: 01, 10, 11, or 22. By default set to
00. For more information, click on
The way to search.
0when you want the first exact match in a range that is not ordered.
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 search key.
2when the range is sorted in descending order and you want the smallest value that is greater than or equal to the
The function accepts values for both axes (column and row). For example: 01, 10, 11, or 22.
If you use
2 in any of the axis (column or row) and the ranges are not properly ordered, the outcome can be unpredictable.