Vlookup In Excel (How to use with example)

What is Vlookup command explain 

Vlookup is very strong command in Excel ,User can use this command in same excel sheet or can link with other 
Here  is an example of a list.  In this case it’s a list of students with student id ,name,telephone number  
Table 1

Usually lists like this have some sort of unique identifier for each item in the sheet.  In this example, the unique identifier is in the “Student_id” column.  Note:  For the VLOOKUP function to work with a list, that list must have a column containing the unique identifier , and that column must be the first column in the table.  Our sample database above satisfies this criterion.

The difficult part of using VLOOKUP is understanding exactly what it’s for.  So let’s see if you can get that clear 

VLOOKUP extract data/information from a database based on a supplied instance of the unique identifier.

Now we need to retrieve name from table A 

open function menu

above box will appears that allows us to find and select any of the functions/command  available in Ms Excel.  To find the one we arelooking for, we could type a search term like “lookup”   The Excel would return us a list of all lookup-related functions in MS Excel.  VLOOKUP is the second one in the list.  Select it an click OK…

 

The Function option will box appears, prompting us for all the options needed in order to complete the VLOOKUP function.  

1. What unique column are you looking up in the database?
2. Where is the excel database.
3. Which piece of information from the table1, link and associated  with the unique identifier, do you wish to have retrieved for you?

The first three arguments are shown in bold, indicating that they are mandatory arguments (the VLOOKUP function is incomplete without them and will not return a valid value).  The fourth option is not bold, meaning that it’s optional:

The first option we need to complete is the Lookup_value argument.  The function needs us to tell it where to find the unique identifier (the item code in this case) that it should be returning the description of.  We must select the item code we entered earlier (in A2).

Click on the selector icon to the right of the first argument:

Vlookup(

Select column that is associated      A2

Now Select Array column from table 2

For further please visit http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/