VLOOKUP Function

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.

Learn MS Excel


Ask Questions

Ask Question