The VLOOKUP function in Excel
The VLOOKUP function in Excel is used to search for a value in the first column of a table and return a value in the same row from a specified column.
Syntax of VLOOKUP
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Parameters
lookup_value: The value you want to search for.
table_array: The range of cells that contains the data (including the column with the...