INDEX(...)
How to VLOOKUP() with two conditions.
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
This formula is based on adding two criteria by using ampersand operator (&). This criteria 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.