Category: Lookup and reference
Returns a reference offset from a given reference
OFFSET(reference, rows, cols, [height], [width])
Category: Lookup and reference
Looks up values in a reference or array
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.