Please enable JavaScript to view the comments powered by Disqus.


How to Vlookup and match values for given conditions.

The formula works by adding two criteria by means of ampersand operator (&). Thus created 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