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.