Looks up values in a vector or array
=LOOKUP(lookup_value, lookup_vector, [result_vector])
=LOOKUP(2, A1:A10, B1:B10)