Excel Spreadsheet is one program you can’t escape to learn how to use while in school or in office settings. One of the most popular encounters with excel is how to extra value from one Excell cell and use it in someplace else in Excel. You could better pose this question as to *how do you retrieve a value from one Excel cell and use it someplace else in Excel. *In this post, I’ll teach you **how to do a vlookup on Excel.**

We’ll cover some salient information you need to know when you want to do a vlookup in Excel Spreadsheet. When it comes to Excel, you need to take more tutorial most especially for dummies.

This vlookup tutorial will explain the nitty-gritty of how you are a beginner can easily do a vlookup in your Excel Spreadsheet work. At some point, you may need to take a video tutorial whenever it appears complicated.

**What We Discussed**Open

## What is vlookup?

It’s good to know *what is vlookup* before you learn *how to do a vlookup *in your Excel.

Vlookup is a function in Excel Spreadsheet that allows users to search for cell contents and receive it from another column. The word vlookup is a combination of **“v”** which stands for **vertical**, which look up data on the **left column** of the table to want to search for cell’s content.

It’s not necessary to be on the current worksheet you are working on. It could be another. What is most important is that it requires **command key **and** four arguments.**

With this function, you will be able to choose between **exact match lookup** or **approximate lookup.**

For instance, let’s say you want to look up a product name like **SKU. **You can decide to go for the exact match or approximate match.

## How to do a vLookup

Before you can *do a vlookup in Excel*, you first need to know the *name of the product you want to look up*. Once you know the name of the product you want to look up, here is a procedure you can follow to do your vlookup as an expert.

1. Open the **Excel Spreadsheet **program where you want to calculate the vLookup formula.

2. In the excel menu click on the** formula option**

3. When you clicked on the formula, you will see some ribbons, click on **Lookup & Reference.**

4. A drop-down menu will appear. Scroll down and click on **vlookup.**

5. This will popup another vlookup sheet where you will **specify the cell,** and in this case, you can do this. Since our lookup value is **H2,** which is where we want to put our product or the name of the tournament.

Therefore, we need to input **H2** in the **lookup_value** box. After that, the Excel will return the product or tournament total rating in cell **H3** as we type the name of the tournament in **H2** cell.

6. Move to the next **table_array** and **specify the data** which you want the vlookup to use for what the command will search for in the **table_array** box.

7. Next is the **col_index_num** which is where you have to specify the data that vlookup will use relevant data in the **column index number**.

For accuracy, vlookup requires you to use a numerical value rather than letter value. So, in this wise, we want vlookup to use the total rating value in column D. So, we’ll enter 4 as the numerical value.

8. Lastly, on the vlookup popup is the **range_lookup** where you will need to specify whether you need an exact match vlookup result or approximate vlookup result.

For an **exact match result** enter **FALSE** and for an **approximate result** enter **TRUE **instead.

9. After you have configured everything as shared above. click on the OK button at the popup of the vLookup tutorial settings.

10. Under the **tournament** where you see **total rating value. **Suppose you want to find the total value rating of **PGA Championship,** we’ll type “**GPA Championship”** in **H2 cell and vlookup will** automatically look up at the total value rating and produce the figure in **H3**.

There are so many things you can do with vlookup in your Excel Spreadsheet. You can find individual value as well as the ability to combine to worksheet into one.

There is more to how to do a vlookup in Excel. If you have different worksheets containing different information such as email address, name, and phone number, you can put them together using **vlookup** if you know how to use it effectively.