How to Use VLOOKUP in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 8 min read · includes 2 free exercises

In short: VLOOKUP looks for a value in the first column of a range and returns a value from another column in the same row. Use FALSE as the last argument to get an exact match.

What VLOOKUP does

Imagine a product table with IDs, names, and prices. You have an ID and you want the price. VLOOKUP finds the row with that ID and gives you back the price, so you do not have to scan the table by eye.

The "V" stands for vertical: it searches down the first column of your range.

VLOOKUP syntax

=VLOOKUP(search_key, range, index, [is_sorted])

A step-by-step example

Here is a small product table in cells A1:C5.

ABC
1IDProductPrice
2P-101Notebook4.50
3P-102Pen1.20
4P-103Backpack32.00
5P-104Stapler8.75

To find the price of P-102:

=VLOOKUP("P-102", A2:C5, 3, FALSE)

This returns 1.20. Here is why:

  1. Sheets looks down column A (the first column of A2:C5) for "P-102".
  2. It finds it in row 3.
  3. The index is 3, so it returns the value from the third column of the range, which is column C.

If you want the product name instead, change the index to 2.

Exact match vs. approximate match

The last argument controls how matching works.

Leaving the last argument out is a common source of wrong results, because it defaults to approximate matching. Get in the habit of typing FALSE.

Common VLOOKUP errors and how to fix them

#N/A: "Did not find value"

#REF!: "Column index is out of range"

Your index is larger than the number of columns in the range. If the range is A2:C5, the largest valid index is 3.

VLOOKUP cannot look to the left

VLOOKUP only returns columns to the right of the search column. If you need to look up an ID in column C and return a value from column A, use INDEX with MATCH, or XLOOKUP.

Make your formula safer

Try it yourself

Use the product table above (A1:C5). Type your formula into the box, starting with =, then press Check.

Exercise 1: Find a price

Write a formula that returns the price of product P-104, using an exact match.

Hint: the price is in the 3rd column of A2:C5, and an exact match needs FALSE as the last argument.

Exercise 2: Find a product name

Write a formula that returns the product name for ID P-103, using an exact match.

Hint: the name is in the 2nd column of the range. Change the index.

VLOOKUP alternatives

Syntax and behavior in this guide were checked against Google's VLOOKUP help page. See all guides.