How to VLOOKUP from another sheet in Excel and Google Sheets

Excel & Google Sheets

=VLOOKUP(D2, Sheet2!A:B, 2, FALSE)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1Start the VLOOKUP as usual with the value to find in D2.
2For the table, reference the other tab: Sheet2!A:B.
3Finish with the column number and FALSE for an exact match.

Tips

If the sheet name has spaces, wrap it in single quotes: =VLOOKUP(D2, 'Sales Data'!A:B, 2, FALSE).
In Google Sheets you can also pull from another file with IMPORTRANGE.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

How do I reference a sheet name with a space?

Wrap it in single quotes, e.g. 'Sales Data'!A:B. Without quotes the space breaks the reference.

More on VLOOKUP

VLOOKUP

Look up a value in the first column of a range and return a value from another column in the same row.

How to VLOOKUP with multiple criteria

Look up a value that matches two or more conditions using INDEX/MATCH with joined keys. Works in Excel 365 and Google Sheets.

Fix #N/A

Fix #N/A errors in VLOOKUP in Excel and Google Sheets — covers missing matches, extra spaces, data-type mismatches, and range mistakes.

How to fix VLOOKUP returning #N/A

VLOOKUP shows #N/A when it can’t find a match. Here are the real causes — exact-match, spaces, text-vs-number — and how to fix each.

Fix Wrong value

VLOOKUP returns an incorrect value in Excel and Google Sheets — fix wrong column index, approximate match mode, unsorted data, and duplicate lookup keys.

XLOOKUP vs VLOOKUP: which to use

XLOOKUP looks in any direction, defaults to exact match, and has a built-in not-found value. Here is when to use each over VLOOKUP.

Formulas used

VLOOKUP XLOOKUP INDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026