A function that looks up and retrieves a value from a table or range based on a given value.

To use VLOOKUP, you need to provide four arguments:

• lookup_value: the value to search for in the first column of the table or range.
• table_array: the table or range of cells where to search for the lookup_value and return a matching value.
• col_index_num: the number of the column in the table_array from which to return a value.
• range_lookup: a logical value that specifies whether to search for an exact match (FALSE) or an approximate match (TRUE or omitted).

Some examples of using VLOOKUP are:

• To look up the price of a product by its name, use =VLOOKUP("Product A", A2:B10, 2, FALSE) ¹
• To look up the email address of an employee by their ID, use =VLOOKUP(4679, D3:F9, 3, FALSE) ²
• To look up the grade of a student by their score, use =VLOOKUP(85, H2:I6, 2, TRUE) ³