The Microsoft Excel Lookup & Reference Functions !
The Excel VLOOKUP function help you to Search or find your value vertically from a data table. V stand for Vertical in the Vlookup Function.
Syntax : - VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
The VLOOKUP function syntax has the following arguments :- lookup _value: Is the value that help to find its value like [Price, Grage, Star Rating] based on it. table_array:- Is the table of data or table array that VLOOKUP searches to find the information. The table_array must contain at least two columns of data. The first column contains the lookup_values. col_index_num :- Is number of the column in the table_array that contains the data you want returned. range_lookup :- A logical value (TRUE or FALSE or 1 or 0) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. |