INDEX(...)
Using MATCH() and INDEX() to VLOOKUP() multiple 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
In this formula we have added two criteria by using ampersand operator (&) that will be looked up in a range combined in a similar fashion. The result will be used to fetch back the results from the required range of cells.