VLOOKUP
Lookup

Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify

Syntax:

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

Example:

=VLOOKUP(A2,B2:D7,2,FALSE)