Advanced VLOOKUP





In this article we will learn about how we can use Vlookup formula in Microsoft Excel 20101 and 2013.
 

VLOOKUP: The Vlookup formula returns a value from the intersection between the found lookup value in the leftmost column and a column index number in the Table Array.

Syntax of “VLOOKUP” function:            =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
 

Uses of Vlookup Function

We use this function to pick the values from one data to another, but the condition is we should have the common values in both data’s so we can easily pick the value.

Let’s take an example and understand how and where we can use Vlookup function in Microsoft Excel 2010 and 2013.

Example 1: We have 2 data sets. In which we have require joining date from 1st data to 2nd data.
 
img1
 
To pick the value from 1st data to 2nd data we have common value is Emp. code, So we will put the Vlookup function through Emp. code follow below mentioned steps to pick the joining date:-

  • Select the cell H13 and write the formula.
  • =VLOOKUP(G3,A3:B13,2,0)press enter.
  • The function will return the joining date for this L2399 Emp code.
  • To return the date of joining to all the employees, Copy the same formula and paste in the range H4:H13.

 
img2
 
Note: If the common value we do not have in other data from which we want to pick the data so formula will give the #N/A error. As you can see in above snapshot the employee code L1089 in not available in 1st data set so formula is giving the error.

This is all about the Vlookup function in Microsoft Excel 2010 and 2010.
 
 



One thought on “Advanced VLOOKUP

  1. I am interested in Tip 2 to solve my problem. Col A has names and Titles in it. Ex [LName],[Title], [FName]. Titles repeat, one to many. In Column E, I wanted certain titles inserted; otherwise leave blank. Is there a VLOOKUP formula that will handle that? Many Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *


− 1 = one

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>