description:
Return the average (arithmetic mean) of its arguments specified by 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. |