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 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.