MATCH function

description:

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

 

syntax:

=MATCH( lookup_valuelookup_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.