FormulaCraft

How to use VLOOKUP across multiple sheets in Excel and Google Sheets

Topic:VLOOKUP
Excel & Google Sheets
=VLOOKUP(A2,PriceList!$A$2:$B$6,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

  1. 1Place your lookup table on a separate sheet, e.g. a sheet named 'PriceList' with keys in column A and values in column B.
  2. 2On your working sheet, start typing =VLOOKUP(A2, then click the PriceList tab and select the table range — Excel/Sheets will insert the sheet reference automatically.
  3. 3Complete the formula: =VLOOKUP(A2,PriceList!$A$2:$B$100,2,FALSE). Lock the range with $ signs so it doesn't shift when you copy the formula down.

Tips

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

Can I look up across sheets in a different workbook/file?

In Excel you can reference a closed or open workbook: =VLOOKUP(A2,[OtherFile.xlsx]Sheet1!$A:$B,2,FALSE). In Google Sheets, use IMPORTRANGE to bring in data from another file first, then VLOOKUP against that range.

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-to

How to VLOOKUP from another sheet

Pull a value from a different tab with VLOOKUP by prefixing the range with the sheet name. Works in Excel and Google Sheets.

Error fix

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

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.

Error fix

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.

How-to

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.

Formulas used

VLOOKUPIMPORTRANGEINDEXHLOOKUPVSTACKHSTACKREDUCEISREF

Related tasks

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

Last reviewed: