Formulas > =LOOKUP()
How To Use LOOKUP() Function in Google Sheets
Description
How To Actually Use LOOKUP() in Sheets
LOOKUP(search_key, search_range|search_result_array, [result_range])
Try LOOKUP yourself
In the range A1:A10, use the LOOKUP function to find the value in B1:B10 that corresponds to the search key in A1. The formula should return the value from B1:B10 based on the position of the search key in A1:A10.
Hints (2)
-
Make sure to specify the correct search range and result range.
-
Remember that LOOKUP returns the value from the same position as the search key.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the LOOKUP() formula:
Generate a LOOKUP() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses LOOKUP(). 2 free AI generations, no signup. Members get unlimited use.
Generate a LOOKUP() formula