MATCH function


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



=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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.