---
title: "How to Use VLOOKUP in Google Sheets"
h1: "How to Use VLOOKUP in Google Sheets"
description: "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."
route: "/learn/how-to-use-vlookup-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-use-vlookup-in-google-sheets"
---

# 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 Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm6hg1gma006nlb0c2isoznuo/tour

Tour id: cm6hg1gma006nlb0c2isoznuo

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.