Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
Description
How To Use in Sheets
LOOKUP(search_key, search_range|search_result_array, [result_range])
0Better Sheets Tutorials
No videos yet. Stay tuned!