Please enable JavaScript to view the comments powered by Disqus.


INDEX() and MATCH() with two criteria.

The MATCH() formula uses ampersand operator (&) to connect the criteria. The respective ranges are also combined using this ampersand sign. The number that is retrieved is used to feed to the second argument of INDEX and thus we retrieve the value. 

Used Functions

Category: Lookup and reference

Uses an index to choose a value from a reference or array


INDEX(array, row_num, [column_num])

Category: Lookup and reference

Looks up values in a reference or array


MATCH(lookup_value, lookup_array, [match_type])

Lets chat on this