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

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

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

VLOOKUPIMPORTRANGEINDEX

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

Last reviewed: