Please enable JavaScript to view the comments powered by Disqus.


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

Performing VLOOKUP() with two criteria

This formula is based on adding two criteria by using ampersand operator (&). This criteria 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