Excel Formulas to VLOOKUP a data From Another Worksheet!!
Tags: excelformula, excelformulas
Published: 2021-02-11 08:11:12

---
title: Excel Formulas to VLOOKUP a data From Another Worksheet!!
published: true
date: 2021-02-09 15:39:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-vlookup-a-data-from-another-worksheet/
---

When you are working with multiple spreadsheets in Excel, sometimes you need to look up a value from another sheet. In this case, what would you do? Here we will provide some cute formula to **find the data from another worksheet in Excel by using the VLOOKUP function**. Let’s see them below!! 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)

## General Formula:

- Use the below formula to look up a value from another sheet in Excel.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(lookup,sheet!range,column,match)**

## 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/)**.
- **Lookup** – It is the criteria to retrieve a value.
- **Range** – It represents the input data from your worksheet.
- **Sheet** -It is the sheet number or name.
- **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.

## Example:

Refer to the below example image.

- Here we will enter the input values in **sheet 2**. Now we want to find the value in sheet 1 based on the input from sheet 2.

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

- Apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section or any cell where you want to display your result.

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

- Finally, press the **“Enter”** key to get the results.

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

## Bottom-Line:

From this short tutorial, you can easily understand how to **find the data from another sheet in Excel by using the VLOOKUP function**. Let me know your **feedback** in the below **comment** section. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-find-two-way-lookup-with-vlookup/)**
- **[Excel Formulas to VLOOKUP by Date ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-vlookup-by-date/)**