LOOKUP function


DESCRIPTION:

Look up a value in a one-column range.

 

SYNTAX:

=MATCH( lookup_value, lookup_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.