Please enable JavaScript to view the comments powered by Disqus.


How to VLOOKUP() with two conditions.

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


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