VLOOKUP function - Excel

Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) ... This article describes the formula syntax and usage of the VLOOKUP function (function: A prewritten formula that takes a value or values, performs an operation, and returns a va

office.microsoft.com