Excel VLOOKUP Tutorial for Beginners: Learn with Examples

[soybean]

Step 4) Argument 2: Choose the lookup table or the table array in which you want VLOOKUP to search for the corresponding value.(In this case, choose the columns Quantity and Discount)

 

[soybean]

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.

 

[soybean]

Step 5) Argument4: Last argument would be the condition for Approximate Matches or Exact Matches. In this instance, we are particularly looking for the Approximate matches (TRUE Keyword).

 

[soybean]

tep 6) Press ‘Enter.’ 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.

NOTE: If you want to use TRUE as the last parameter, you can leave it blank and by default it chooses TRUE for Approximate Matches.

 

[soybean]

Vlookup function applied between 2 different sheets placed in the same workbook​

Let’s see an instance similar to the above case scenario. We are provided with one workbook containing two different sheets. One where Employee’s Code along with Employee’s Name and Employee’s Designation is given another sheet contains Employee’s Code and respective Employee’s Salary (as shown below).

 

[soybean]

SHEET 1:

.................

 

[soybean]

SHEET 2:

Download the above Excel File

 

[soybean]

Now the objective is to view all the data in one page, i.e., Sheet 1 as below:

 

[soybean]

VLOOKUP can help us aggregate all the data so that we can see Employee’s Code, Name, and Salary in one place or sheet.

We will start our work on Sheet 2 as that sheet provides us with two arguments of the VLOOKUP function that is – Employee’s Salary is listed in Sheet 2 which is to be searched by VLOOKUP and reference of the Column index is 2 (as per the lookup table).

 

[soybean]

Also, we know we want to find the employee’s salary corresponding to the Employee’s Code.

Moreover, that data starts in A2 and ends in B25. So that would be our lookup table or the table array argument.