Applying a Vlookup is really simple:
The Syntax of Vlookup is : =VLOOKUP( lookup_value, table_array, column_index, range_lookup )
where:
1. ‘lookup_value’ specifies the value to be searched inside the ‘table_array’.
2. ‘table_array’ is the range with two or more columns.
3. ‘column_index’ is the relative index of the column whose value needs to be returned by the VLOOKUP function.
4. ‘range_lookup’ is a Boolean value that specifies whether you want VLOOKUP to find an exact match or an approximate match.
http://spreadsheeto.com/wp-content/u.../2015/10/3.png
I would suggest you to have a look at
this article for further details on the topic.