INDEX(...)
Performing VLOOKUP() with criteria ranges in two columns
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
For verifying criteria in two column ranges, the formula combines the values of criteria with ampersand operator (&) and the criteria ranges, too, are combined this way. The result is returned if the respective criteria matches the columns respectively.