Please enable JavaScript to view the comments powered by Disqus.


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

How to perform VLOOKUP() with multiple criteria. 

This formula works by  adding 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