Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to VLOOKUP from another sheet in Excel and Google Sheets
Topic:VLOOKUPExcel & 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
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.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
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
See all →Reference
VLOOKUP
Look up a value in the first column of a range and return a value from another column in the same row.
How-toHow 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.
Error fixFix #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-toHow 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.
Error fixFix 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.
How-toXLOOKUP 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.