How to use VLOOKUP in Google Sheets
Look up a value
How VLOOKUP works
VLOOKUP finds a value in the first column of a table and returns a value from another column in the same row.
Rep for order 1003. Column 2 of the table is Rep.
What you’ll do
You’ll find the product for one order number. Looking up a value by its ID is one of the most used skills in spreadsheets, from price lists to customer records.
Try it
Type =VLOOKUP(1003,A2:H11,2,FALSE) into K2 and press Enter. Watch what the sheet does.
The result will appear in K2.
Click the sheet and press Ctrl+/ Mac ⌘+/ to see every shortcut this sheet knows. Press it again, or Esc, to close it. In Sheets it opens the full list. (Show the list of shortcuts.)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Rep | Region | Product | Units | Price | Order date | Ship date | |||
| 2 | 1001 | Ana | West | Desk | 3 | 240 | 1/5/2026 | 1/9/2026 | |||
| 3 | 1002 | Bo | East | Chair | 8 | 85 | 1/12/2026 | 1/20/2026 | |||
| 4 | 1003 | Cy | West | Lamp | 12 | 30 | 1/19/2026 | 1/22/2026 | |||
| 5 | 1004 | Di | North | Desk | 2 | 240 | 2/2/2026 | 2/13/2026 | |||
| 6 | 1005 | Ana | West | Chair | 5 | 85 | 2/9/2026 | 2/12/2026 | |||
| 7 | 1006 | Eve | South | Shelf | 4 | 120 | 2/16/2026 | 2/27/2026 | |||
| 8 | 1007 | Bo | East | Lamp | 20 | 30 | 3/2/2026 | 3/4/2026 | |||
| 9 | 1008 | Cy | West | Shelf | 1 | 120 | 3/9/2026 | 3/18/2026 | |||
| 10 | 1009 | Di | North | Chair | 6 | 85 | 3/16/2026 | 3/19/2026 | |||
| 11 | 1010 | Eve | South | Desk | 7 | 240 | 3/23/2026 | 4/1/2026 |
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how VLOOKUP works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
In K2, find the product for order 1006.
One payment, no subscription.