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.
81% OFF online library of tutorials for mastering Google Sheets
LOOKUP()
Description
How To Use in Sheets
LOOKUP(search_key, search_range|search_result_array, [result_range])
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.