How To Use Excel Vlookup With Examples

Now let us look at a few examples in this tutorial based on products table for using the excel vlookup function to make things clearer.

How to use excel vlookup with examples. Example 5 getting the last value from a list you can create a vlookup formula to get the last numerical value from a list. To use the vlookup function in our excel example the data is to be organized to its good extent so that it is easy to use the function. Let s say that we manage a restaurant and are placing our weekly orders to suppliers. In our example the output data is located in the 3 rd column of the table so we enter the number 3 in the formula. Vlookup formula will be applied to the mentioned cell reference and when you enter any number in the quantity field it will show you the discount imposed based on approximate matches in vlookup.

The image above is self explanatory. The data is organized in such a way that when we are using vlookup it should be in the left to the right format. The vlookup function in excel performs a case insensitive lookup. In this example you will see how to use two or more table arrays in the excel vlookup formula. In this step we need to tell excel which column contains the data that we want to have as an output from the vlookup.

You may download the excel sheet for running this and other examples in your system or look at the graphic with each example. How to use vlookup in excel. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. As a result the vlookup function returns the salary of mia clark first instance. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table.

In the next part of our tutorial we will discuss advanced vlookup examples that will teach you how to vlookup multiple criteria return all matches or nth occurrence look up across multiple sheets with a single formula and more. The largest positive number that you can use in excel is 9 99999999999999e 307. If you want to use true as the last parameter you can leave it blank and by default it chooses true for approximate matches. 2 excel vlookup with 2 tables of values. The vlookup example for getting the price.

In the following image you re seeing how i have made a formula using vlookup and if functions to choose one of the two table arrays. That s how to use vlookup in excel at the basic level. This can be illustrated in the below screenshot. How does this formula work. To vlookup between two or more workbooks enclose the workbook name in square brackets and put it before the sheet name.