Excel Vlookup

Vlookup is most widely used formula in Excel. Vlookup stands for “Vertical Lookup”. It searches the first column of a table array and then selects value in right hand side columns of table array in the same row.

Syntax:

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)



Lookup_value:


Lookup value is the value that has to be searched in the first column in left hand side of the tabl array. If lookup_value is found in the first column of the table array, it will look for the data in right hand side columns in same rows. Lookup_value works as a primary key which can be data value or reference. These can be numeric or text values.


Table_array


Table array can be data columns containing two or more columns. First columns in the table array should be the value containing lookup_value. Like lookup_value, these values can be numeric or text values.


Col_index_num:


Col_index_num is numeric value which tell formula that from which column data will be returned. It is defined in numbers like 1,2 3 and so on which are identified as column number to right hand side.


Range_lookup:


Range lookup is a simple logical value: true or false to specifies whether you want find an exact match or an approximate match. That means if selected “FALSE”, formula will return value on exact match and will return error: #N/A in case of no value to return. In case of approximate match (TRUE), an exact or approximate match is returned and in case exact match is unavailable, next largest value that is less than lookup_value is returned. ’1′ and ’0′ can be also used in place of TRUE and FALSE respectively. Default value for range lookup is TRUE, if left blank.