Home MS Excel TutorialExcelTips and Tricks VLOOKUP On Multiple Sheets in Excel

VLOOKUP On Multiple Sheets in Excel

by Easy Excel Tutorials

VLOOKUP On Multiple Sheets in Excel

There are situations when you have data on many sheets. In this lesson you will teach yourself how to do vlookup in this case.

Your task:

So, you have your data both in Sheet1 and Sheet2. You want to create a vlookup formula which will analyze data in these two sheets. Your formula will look like this:


vlookup multiple sheets


The trick is to write Sheet2!A1:B200 instead of just A1:B200. Sheet2! is the information that you analyze data from the sheet which name is Sheet2.


Lookup value is in A1 cell. You analyze data in Example_Sheet in A1:B10 table array. Number of column is 2. You want to exact match. Your formula is:



You can download the Template here – Download

Further reading: 
Backwards Vlookup
Basic concepts 
Getting started with Excel
Cell References

You may also like