VLOOKUP

Finds a value in the first column of a table and returns a value from the same row.

Group: Lookup

Syntax

VLOOKUP(lookup_value, table, column_number, [exact])

Example

← All of Excel Function Reference