LOOKUP
The LOOKUP function in Google Sheets 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.
Function Syntax and Parameters
Syntax: LOOKUP(search_key, search_range|search_result_array, [result_range])
Parameters:
search_key: The value to search for in the search range or array.search_range|search_result_array: The range or array to search in.result_range: [Optional] The range to return a value from. If omitted, the search range or array will be used.
Use Cases and Scenarios
- Database Lookup: Retrieve a value from a database by searching for a specific key.
- Pricing Table: Find and display the price of a product based on its code.
- Stock Search: Look up stock prices for a list of companies.