Excel LOOKUP function

Function              LOOKUP

Description        Excel LOOKUP function looks in a one-row or one-column range (known as a lookup_vector) for a value and returns a matching value from the same position in a second one-row or one-column range.

Syntax  LOOKUP(lookup_value, lookup_vector, [result_vector])

lookup_value  The value to which is to lookup.

lookup_vector  The one-row, or one-column range where to search.

result_vector  The one-row, or one-column range of results.

Example: