Please enable JavaScript to view the comments powered by Disqus.


Matching multiple criteria with MATCH() and return respective value

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. 

Used Functions

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])

Lets chat on this