Lookup for multiple matches in a column or row using FILTER function in Excel - Office 365

The VLOOKUP function looks for a value in leftmost column of a table and returns a value in the same row from the specified column. If there are multiple matches VLOOKUP returns the first value. To get multiple values you can use the FILTER function. The FILTER function filters a range of data based on supplied criteria and the result is an array of matching values from the original range.

To download the practice Excel file please click on the link below