There are situations when you have data on many sheets. In this lesson you will teach yourself how to do vlookup in this case.
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:
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:
Further reading: How to Remove N/A! Errors in VLOOKUP Formula? How to create many to many lookup? Backwards Vlookup