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.

How To Use in Sheets

LOOKUP(search_key, search_range|search_result_array, [result_range])

External Links

0Better Sheets Tutorials

No videos yet. Stay tuned!