The VLOOKUP function in Microsoft Excel searches for a value in the first column of a table array and returns a value in the same row from another column.
The VLOOKUP function takes three required variables and one optional variable. The required variables are Lookup_value, Table_array, and Col_index_num. The optional variable is Range_lookup.
The Lookup_value is the string that .
the user is trying to match. The Table_array specifies two or more columns of data. The Col_index_num allows the user to specify which column of the Table_array that the VLOOKUP should return. The Range_lookup allows the user to specify if the match must be exact or approximate.
As an example, the following formula will look for the word apples in the first ten rows of column A: VLOOKUP("apples", A1:B10, 2, TRUE). If apples is found in column A, the value in the same row of column B will be returned.
More Reference Links: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx https://kb.wisc.edu/helpdesk/page.php?id=1237
