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
General Formula:
- Use the below formula to look up a value from another sheet in Excel.
=VLOOKUP(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.
- 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.
- Apply the above-given formula to the formula bar section or any cell where you want to display your result.
- Finally, press the “Enter” key to get the results.
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 **and Excel Formulas *!! **
Top comments (0)