INDEX(...)
How to retrieve multiple values for a given criteria by Vlookup concept
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: Statistical
Returns the k-th smallest value in a data set
Syntax
SMALL(array, k)
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
0
The formula verifies for the cells in the range that matches the given criteria by equating the values, returning the row numbers, that are feed to small to get them one by one. In the index function return the corresponding values from our data.