VLOOKUP() i.e,Vertical Lookup, is a Lookup and Reference function which takes the argument "lookup_value, table_array, col_index_num, range_lookup" and searches for a value in the column of a table array and it returns a value in the same row from another column in the table array.
Formula:
=VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) In the above syntax, the argument "lookup_value" denotes the numerical or text value to be specified in the first column of the table, "table_array" denotes two or more columns in a table and it is used as a reference, "col_index_num" refers to the column number in a table from where the related value will be reproduced "Range_lookup" denotes a logical value and it indicates whether the user wants to find accurate match using this function.
Video Tutorial:
Let us view how the VLOOKUP function can able to return the text from column with the help of below video.