Please enable JavaScript to view the comments powered by Disqus.


How to workout VLOOKUP() for multiple criteria. 

The formula working by using ampersand operator (&) that joins the criteria-values 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


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