MATCH function


DESCRIPTION:

Return the average (arithmetic mean) of its arguments specified by a given criteria.

 

SYNTAX:

=MATCH( lookup_value, lookup_array[match_type] )

 

REQUIRED ARGUMENTS:

lookup_value

The value to match in lookup_array.

lookup_array

A range of cells or an array reference.

 

OPTIONAL ARGUMENTS:

[match_type]

Determine the type of match. 1 is the default type.