How to Use VLOOKUP
in Google Sheets

Open your Google Sheets document and ensure you have a dataset with a column that contains the value you want to look up.

Select the cell where you want the VLOOKUP result to appear.

Type the VLOOKUP formula: =VLOOKUP(search_key, range, index, [is_sorted]). Replace search_key with the value you want to search for, range with the dataset range, index with the column number to return the value from, and [is_sorted] with either TRUE or FALSE (depending on whether your data is sorted).

Press Enter to apply the formula. The result from the specified column will appear in the cell.

Double-check your formula for accuracy, and if necessary, adjust the range or column index for the correct lookup value.

Drag the formula down to apply it to multiple rows if needed.