What is 'VLOOK' ? Explain it with its syntax.

VLOOKUP function stands for vertical lookup, it helps to find specific information in large data tables such as an inventory list of parts or a large employees contact list this function searches and matches first the required value from the column of a range of cells and then returns a value from any cell on the same row of the range. Syntax VLOOKUP (lookup_value, table_array,col_index_num, range_lookup) where Lookup_value : The value to search in the first column of the table lookup_value can be a value or a reference. If lookup_value is smaller than the smallest value in the first column of table_array, Vlookup returns the # N/A error value. Table_array : Two or more columns of data use a reference to a range or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text numbers, or logical values, uppercase and lowercase texts are equivalent. Col_index_num : The column number in table array from which the matching value must be returned. A col_index_num of $\displaystyle 1$ returns value in the first column in table_array and value $\displaystyle 2$ returns it in second column. Less than $\displaystyle 1$ returns # VALUE error. Greater than the number of columns # REF! Error. Range_lookup : If true or omitted an exact or approximate match is returned. If false it will only find an exact match.