|Return the average (arithmetic mean) of its arguments specified by given criteria.|
|=MATCH( lookup_value, lookup_array, [match_type] )|
|lookup_value||The value to match in lookup_array.|
|lookup_array||A range of cells or an array reference.|
|[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.