VLOOKUP Tutorial for Beginners — Master Excel & Google Sheets in 10 Minutes

VLOOKUP is the most-used lookup function in Excel — and the most misunderstood. Over 750,000 people Google "VLOOKUP tutorial" every month. If you've ever stared at a spreadsheet wondering how to match data between two tables, this guide is for you.

What VLOOKUP Actually Does

=VLOOKUP(lookup_value, table_array, col_index_num, FALSE)

In plain English: "Look for this value in that table, and give me the value from column N. Make sure it's an exact match."

Real Example: Find a Product Price

Sheet 1 has Order IDs. Sheet 2 has a price table:

Order ID	A001	A002
Price	$45.00	$78.50

Formula: =VLOOKUP("A001", A:A, 2, FALSE) → Result: $45.00

Common Mistakes & Fixes

#N/A error: Value doesn't exist in lookup table — check for typos or extra spaces
Wrong column number: col_index starts at 1 (the first column in your range)
Approximate vs exact match: ALWAYS use FALSE for exact match unless sorting tax brackets
Can't look left: VLOOKUP only searches to the RIGHT — use INDEX-MATCH if you need to go left

VLOOKUP vs XLOOKUP — Which Should You Use?

XLOOKUP (Excel 365/Google Sheets) is the modern replacement: =XLOOKUP(A2, B:B, D:D, "Not found"). It's simpler, faster, and can look left. But VLOOKUP still works everywhere — including old Excel versions, CSV exports, and shared spreadsheets.

Generate Any Excel Formula Free →