Parameter List
The value to search for in the lookup_range. For example: "Super", 123, or A1.
The range of cells to search for the search_key. It must be a single row or column. For example: A1:A5 or C1:E1.
The range of cells to return a value from, corresponding to the position of the found search_key. It must have the same size and orientation as lookup_range.
The value to return if the search_key is not found. For example, "Not Found" or 0.
The type of match to perform. Choose either:
0: Exact match (default).-1: Exact match or the next smaller item.1: Exact match or the next larger item.2: Wildcard match (supports*,~and?).
The order in which to search. Choose either:
1: Search from first to last (default).-1: Search from last to first.2: Perform a binary search in ascending order (range must be sorted).-2: Perform a binary search in descending order (range must be sorted).