LOOKUP function

description:

Look up a value in a one-column range.

 

syntax:

=MATCH( lookup_valuelookup_vector[result_vector] )

 

required arguments:

lookup_value The value to match in lookup_vector.
lookup_vector The one-row, or one-column range to search.

 

optional arguments:

[result_vector] The one-row or one-column range of results.