Use Excel's INDEX Function to Return an Array Vs Value
This video illustrates how to use Excel's INDEX function to return an array values rather than a single value. The result of the INDEX lookup can then be used with other functions such as SUM, MIN, COUNTIF etc
------------------------