Parameter List
Syntax
LOOKUP(search_key, search_range|search_result_array,
[result_range]
)search_key
The value to search for in a row, e.g. "Super", 123, A2, or "Benf*".
search_range|search_result_array
The two-dimensional range or JSON data to consider for the search. The first column must include the search_key. For example: A1:C5.
[optional] result_range
The range from which to return a result.