Tutorial On How To Use Vlookup In Excel

This can be an actual value or a blank cell that will hold a value.

Tutorial on how to use vlookup in excel. In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column. When using the vlookup function in excel you can have multiple lookup tables. The second step is to select the data where this info is available. Vlookup is an excel function.

It can also be used as a worksheet function where the function can be entered as part of a formula in a cell of a worksheet. Create two named ranges. This article will assume that the reader already has a passing understanding of excel functions and can use basic functions such as sum average and today. In this vlookup guide we will learn.

Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. You can use the if function to check whether a condition is met and return one lookup table if true and another lookup table if false. As the name specifies vlookup is a built in excel function that helps you look for a specified value by searching for it vertically across the sheet. Vlookup always looks right ie it requires a lookup table with lookup values in the left most column.

Use vlookup in the formula bar type vlookup. Vlookup performs the search in the first column and retrieves the info from whichever column you specify to the right. In the parentheses enter your lookup value followed by a comma. Look at the example below to understand vlookup.

Learn vlookup the easy way with screenshots examples detailed break down of exactly how the formula works in excel. Vlookup in excel may sound complicated but you will find out that it is a very easy and useful tool once you try it. In the image above example this is table b5f17 and this range is the tablearray argument. For example look for this piece of information in the following area and give me some corresponding data in another column.