HLOOKUP
Lookup

Looks in the top row of an array and returns the value of the indicated cell

Syntax:

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Example:

=HLOOKUP("Value", A1:D4, 2, FALSE)