INDEX(...)
How to Vlookup and match values for given conditions.
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])
Practice INDEX Formula at Sheetzoom
INDEX formula at Microsoft helpCategory: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
0
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.