Excel VLOOKUP Function useful for office.

VLOOKUP is an Excel function to lookup and retrieve data from a definite column in table. VLOOKUP provisions imprecise and exact matching, and wildcards (*/ ?) for restricted matches. The "V" stands for "vertical". Lookup values must look in the first column of the table, with lookup columns to the right.

Syntax :- =VLOOKUP (value, table, col_index, [range_lookup) Enter

Example  Step :-

1.Value:-The value to look for in the first column of a table.

2.Table: - The table from which to retrieve a value.

3.col_index:- The column in the table from which to rescue a value.

4.Range lookup: - optional TRUE = estimated match (default). FALSE = exact match.