INDEX(...)
INDEX() and MATCH() with two criteria.
Used Functions
Category: Lookup and reference
Uses an index to choose a value from a reference or array
Syntax
INDEX(array, row_num, [column_num])
Practice INDEX Formula at Sheetzoom
INDEX formula at Microsoft helpCategory: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
0
The MATCH() formula uses ampersand operator (&) to connect the criteria. The respective ranges are also combined using this ampersand sign. The number that is retrieved is used to feed to the second argument of INDEX and thus we retrieve the value.