81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.