VLOOKUP From Another Sheet / Workbook - WallStreetMojo

All Courses LoginAll BlogsExcel ResourcesVLOOKUP from Another Sheet / WorkbookVLOOKUP from Another Sheet / Workbook

Publication Date :

24 Feb, 2019

Blog Author :

Jeevan A Y

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Share

Find Anything in Excel – Lookup Functions Made Easy!

Table Of Contents

How to Vlookup from Another Sheet / Workbook?

We all know the basics of the VLOOKUP function in excel. Probably for beginners level, you must have practiced the formula from the same sheet itself. Fetching the data from another worksheet or from another workbook is slightly different using the VLOOKUP function in excel.

Let us have a look at how to use VLOOKUP from another sheet and then how it can be used on another workbook.

Table of contents

• How to Vlookup from Another Sheet / Workbook?
  • #1 - VLOOKUP from Another Sheet but Same Workbook
  • #2 - VLOOKUP from Different Workbook
  • Things to Remember About Excel Vlookup from Another Sheet (Same or Different Workbook)
  • Recommended Articles

#1 - VLOOKUP from Another Sheet but Same Workbook

Now copy the result table to another worksheet in the same workbook.

In the Result, Sheet opens the VLOOKUP formula and select the lookup value as cell A2.

Now the table array is on a different sheet. Select the Data Sheet.

Now, look at the formula in the table array. It does not only contain table reference, but it contains the sheet name as well.

Note: Here, we need not need to type the sheet name manually. As soon as the cell in the other worksheet is selected, it automatically shows you the sheet name along with the cell reference of that sheet.

After selecting the range in the different worksheets, lock the range by typing the F4 key.

Now you need not go back to the actual worksheet where you are applying the formula rather here itself. You can finish the formula. Enter the column reference number and range lookup type.

We got the results from the other worksheet.

🔍 Master Excel Lookup Functions with Confidence!

Unlock the true power of Excel with our Excel Lookup Functions Course perfect for students, analysts, and professionals. Learn how to efficiently use VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP, and more to find and manage data with precision.

Learn More →

VLOOKUP Excel Function Video Explanation

#2 - VLOOKUP from Different Workbook

We have seen how to fetch the data from a different worksheet in the same workbook. Now we will see how to fetch the data from a different workbook.

I have two workbooks; one is Data Workbook & Result Workbook.

From Data Workbook, I am fetching the data to Result Workbook.

Step 1: Open the VLOOKUP function in the Result workbook and select lookup value.

Step 2: Now go to the main data workbook and select the table array.

You can use Ctrl + Tab to switch between all the opened excel workbooks.

The table array not only contains table range rathbut it also, but it also contains Workbook Name, Worksheet Name, and data range in that workbook.

We need to lock the table array here. Excel itself locked the table array automatically.

Mention column index number and range lookup to get the result.

Now close the main workbook and see the formula.

It shows the path of the excel file we are referring to. It shows the complete file and subfile names.

We got the results.

Excel Lookup Functions Course Your browser does not support the video tag. Get full access to the Excel Lookup Functions Course and learn how to use essential lookup tools like VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP. Study at your own pace with expert-led video lessons and practical exercises that help you work smarter in Excel. Learn More →

Things to Remember About Excel Vlookup from Another Sheet (Same or Different Workbook)

• We need to lock the table array range if you are fetching the data from the same worksheet or from different worksheets but from the same workbook.
• We need to lock the table array range when the formula is applied to a different workbook. The formula automatically makes it an absolute reference.
• Always remove VLOOKUP formulas if you are fetching the data from a different workbook. If you delete the workbook accidentally, you will lose all the data.

You can Download this Vlookup from Another Sheet or Workbook Excel template here – Vlookup from Another Sheet Excel Template.

FINANCIAL MODELING 2-DAY BOOTCAMP @75% OFF – NEW YEAR SALE

Master Financial Modeling in Just 2 Days | Build and Forecast IS, BS & CF from Scratch | Perfect for Graduates and Professionals Looking to Upskill this Sale.

Join WallStreetMojo YouTube

INVESTMENT BANKING MASTERY PROGRAM @75% OFF – NEW YEAR SALE

Experience the Exact Training Used by Top Investment Banks | Learn FM, DCF, LBO, M&A, Accounting & More | Unlock Wall Street-Level Skills this Sale.

Join WallStreetMojo Instagram

CHATGPT & AI FOR EXCEL COURSE @75% OFF – NEW YEAR SALE

Boost Productivity 10X with AI-Powered Excel | Automate Reports, Eliminate Errors & Advance Your Analytics Skills | Transform Your Workflow this Sale.

Join WallStreetMojo LinkedIn

EXCEL ALL-IN-ONE BUNDLE COURSE @75% OFF – NEW YEAR SALE

Master Excel, VBA & Power BI Like a Pro | 70+ Hours of Expert-Led Training | Learn Real-World Applications & Earn Your Certification this Sale.

Join WallStreetMojo Facebook

Join WallStreetMojo X