Steps to use LOOKUP function in Google Sheets
- Step 1: Click on the cell where you want the result.
- Step 2: Type the formula =LOOKUP(the value you want to look for, the column or row to search in, the column or row to return the value from).
- Step 3: Press Enter to get the result.
Tip: The search range must be sorted in ascending order for the LOOKUP function to work correctly.