Please enable JavaScript to view the comments powered by Disqus.


INDEX(...$C$3:$C$14,MATCH(...C15&C16,A3:A14&B3:B14,0))

Using MATCH() and INDEX() to VLOOKUP() multiple criteria. 

In this formula we have added two criteria by using ampersand operator (&) that will be looked up in a range combined in a similar fashion. The result will be used to fetch back the results from the required range of cells. 


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

Category: Lookup and reference

Looks up values in a reference or array

Syntax

MATCH(lookup_value, lookup_array, [match_type])

Lets chat on this