Excel Formulas to VLOOKUP from Another Workbook ~ Easy Tricks!!
Tags: excelformula, excelformulas
Published: 2021-02-13 06:50:33

---
title: Excel Formulas to VLOOKUP from Another Workbook ~ Easy Tricks!!
published: true
date: 2021-02-12 09:12:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-vlookup-from-another-workbook-easy-tricks/
---

As we all known, the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** can be used in the same workbook. Have you ever tried to apply this VLOOKUP function in two different workbooks? Don’t you know how to do it?  Let’s get into this article. Here I introduce some cute formula to **look up the value from another workbook in Excel by using the VLOOKUP function**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Vlookup another workbook](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Vlookup-another-workbook.png)](https://geekexcel.com/excel-formulas-to-vlookup-from-another-workbook-easy-tricks/vlookup-another-workbook/#main)<figcaption id="caption-attachment-21787">Vlookup another workbook</figcaption>

## Generic Formula:

- You can use the below formula to look up the value from another workbook.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(B1,[workbook][Sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/)!range,column\_no,0)**

## Syntax Explanations:

- **VLOOKUP** – This function will help to lookup data in a range or table by row. Read more on the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **Sheet** – In Excel, the [**Sheet function**](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) returns the index number of the sheet.
- **B1** – It is the specified criteria to look up the value.
- **Workbook** – It defines the workbook name from where the input data is available.
- **Range** – It represents the input data from your worksheet.
- **Column\_No** – This is the column number where the criterion value is available.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

For instance, assume that you have two workbooks. One book consists of input data and another workbook contains the criteria based on the first workbook. In this case how to retrieve the data that are stored in a separate workbook. Just see them below.

- For instance, we have the input range in **Column B** to **Column F** from the **Product data.xlsx**  workbook.

![Input data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-data-1.png)<figcaption id="caption-attachment-21778">Input data</figcaption>

- Now, we need to retrieve the value from this workbook to another (external) workbook.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Criteria-1.png)<figcaption id="caption-attachment-21779">Criteria</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-7.png)<figcaption id="caption-attachment-21780">Enter the formula</figcaption>

- It will display the result to the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-1-1.png)<figcaption id="caption-attachment-21783">Result</figcaption>

## Verdict:

From this guide, you can get some clarification on **how to look up the value from another workbook in Excel by using the VLOOKUP function**. Please feel free to state your **query** or **feedback** for the above article. I reply to **queries** frequently. To learn more, check out  **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[How to use VLOOKUP to Create a Search Box? ~ Complete Guide](https://geekexcel.com/how-to-create-search-box-vlookup-function/)**
- **[Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-find-two-way-lookup-with-vlookup/)**