We rebuilt the editor. Less panel hunting. More shaping.

Guide

How to Use VLOOKUP in Google Sheets

Learn how to efficiently retrieve data from a table using VLOOKUP in Google Sheets. Master this essential function to simplify data management and analysis tasks.

Interactive tour · Open canonical tour

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

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

  3. 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).

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

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

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