OFFSET(...)
Matching multiple criteria with MATCH() and return respective value
Used Functions
Category: Lookup and reference
Returns a reference offset from a given reference
Syntax
OFFSET(reference, rows, cols, [height], [width])
Practice OFFSET Formula at Sheetzoom
OFFSET 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() function when used with "&" sign in its first argument can be used for matching multiple criteria, but it requries use of this sign on the second argument as well. The OFFSET() function is used to bring the respective value from the array.