Please enable JavaScript to view the comments powered by Disqus.


Performing VLOOKUP() with criteria ranges in two columns

For verifying criteria in two column ranges, the formula combines the values of criteria with ampersand operator (&) and the criteria ranges, too, are combined this way. The result is returned if the respective criteria matches the columns respectively. 

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