Excel Formulas to Find the Self-Contained VLOOKUP!!
Tags: excelformula, excelformulas
Published: 2021-02-11 08:10:34

---
title: Excel Formulas to Find the Self-Contained VLOOKUP!!
published: true
date: 2021-01-30 09:13:52 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-self-contained-vlookup/
---

Sometimes, when working with datasheets, we need to find the value based on some other value. For instance, finding the grades of the students based on scores of an Exam. Do you have any good methods for solving this task in Excel? Here, we will introduce the simple formula to make a **self-contained VLOOKUP in Excel**. Let’s get 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)

![Self-contained VLOOKUP](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Self-contained-VLOOKUP.png)<figcaption id="caption-attachment-21556">Self-contained VLOOKUP</figcaption>

## Generic Formula:

- You can use the below formula to make a self-contained VLOOKUP.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(lookup,(table),[column](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/),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 represents the criteria that want to be found.
- **Table** – It is the input data.
- **Column** – It represents the [column](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/) number.
- **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:

Now we are going to find the grades of the students based on their scores. Refer to the below image.

- Here, we will give the input values in **Column**  **B** and **Column**  **C**.

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

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

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-16.png)<figcaption id="caption-attachment-21554">Enter a formula</figcaption>

- Finally, press the **ENTER** key, it will display the result in the selected cell.

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

## Closure:

From this tutorial, we have described the simple formula used to find the **Self-Contained VLOOKUP value in Excel**. Make use of it. 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 Partial Match with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-find-partial-match-with-vlookup/)**
- **[Excel Formulas to Merge the Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-merge-tables-with-vlookup/)**
- **[Formula to find Vlookup Return Matching Values from Multiple worksheets](https://geekexcel.com/formula-to-find-vlookup-return-matching-values-from-multiple-worksheet/)**