# VLOOKUP (Excel lesson 12 of 45)

> Find a row by its key and pull back a value from the same row.

Source: https://spreadsheetpractice.com/learn/vlookup · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Lookups"
- **Time:** about 9 minutes, 2 graded exercises
- **Functions:** `VLOOKUP`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=VLOOKUP(F2,$A$2:$D$9,2,FALSE)`: Product name (column 2)

## How it works

`=VLOOKUP(lookup_value, table, column_number, FALSE)` searches the first column of the table for the value and returns the value from column number N of the same row.

Always pass `FALSE` for an exact match. The default, TRUE, assumes the first column is sorted and can quietly return the wrong row. Lock the table with $ so it stays put when you fill down.

## Syntax

| Formula | What it does |
|---|---|
| `=VLOOKUP(F2,$A$2:$D$9,2,FALSE)` | Product name (column 2) |
| `=VLOOKUP(F2,$A$2:$D$9,3,FALSE)` | Price (column 3) |

## Watch out for

- VLOOKUP only looks right of the first column.
- A hard-coded column number breaks when someone inserts a column. XLOOKUP, next, fixes both.

## The exercises

Solve them in the live grid at [VLOOKUP](https://spreadsheetpractice.com/learn/vlookup). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Look up product names.** In G2, look up the product name for the SKU in F2. Fill down to G4.
2. **Look up prices.** In H2, look up the price for the SKU in F2. Fill down to H4.

Previous: [Charts: pick the right one](https://spreadsheetpractice.com/learn/charts) · Next: [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
