VLOOKUP

Syntax

=VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup])

Description

Looks for a value in the first column of a table and returns a value in the same row.

Related Functions