Vlookup basics pdf

Table of Contents. We use this formula to see usually a special value in a big database where manual search become troublesome. We can use this to see the value vertically. So its use can be done to see the value inside of any cell of column.

Note : Keep remember that lookup value should always in first column of range so that it can work better. VLOOKUP is designed to retrieve the organised data from vertical rows of table where each row represents a new record.

We will try to understand by one sample problem. Suppose, we have one table which is shown below. Like we cannot retrieve the name from the above table. Because we are getting the Salary based on the Id but Name is not right side of Id column.

The first column of values in the table is column 1. After pressing OK. You will find the salary of Id as If you want to find the salary of any employee further, just change the with the desired Id. You will find the salary of that desired number. Find the vlookup value between the workbooks and worksheets.

As shown below, certain Company has imposed discounts on the quantity of items ranging from 1 to 10, Now it is uncertain that the customer buys exactly hundreds or thousands of items. In other words, we do not want to limit them for finding matches to just the values present in the column that are 1, 10, , , Here are the steps:. In the parenthesis enter the set of Arguments for the above instance.

Argument 1: Enter the Cell reference of the cell at which the value present will be searched for the corresponding value in the lookup table. In this case, choose the columns Quantity and Discount. Step 5 Argument 3: The third argument would be the column index in the lookup table you want to be searched for the corresponding value.

We are provided with one workbook containing two different sheets. Moreover, that data starts in A2 and ends in B So that would be our lookup table or the table array argument. Step 3 Argument 1: Enter the cell reference which contains the value to be searched in the lookup table. Step 4 Argument 2: In the second argument, we enter the lookup table or the table array.

However, in this instance, we have the lookup table situated in another sheet in the same workbook. Therefore, for building a relationship we need to enter address of the lookup table as Sheet2! A2:B25 — A2:B25 refers to the lookup table in sheet 2. Step 5 Argument 3: Third argument refers to the Column index of the column present in Lookup table where values ought to be present. You can play around using more instances. Skip to content. Report a Bug. Previous Prev. Next Continue.

Home Testing Expand child menu Expand. SAP Expand child menu Expand. Web Expand child menu Expand. Must Learn Expand child menu Expand. Big Data Expand child menu Expand. Live Project Expand child menu Expand.