Index/Match to Return 1D array to be used in a sumproduct

[david0985]

Hi guys,

I would like to calculate a weighted average using sumproduct. The issue is the databases I am pulling from are asymmetrical. Essentially what I want to do is do an index/match that returns an array (1 row of data) which is based off of two criteria, location and date. I already know how to perform a 2 criteria index/match using &, but I am not sure how to make the return of the index/match be an array versus a single cell.

I have attached a simplified version of my data. My actual data has hundreds of rows so the formula is not trivial.

Thanks in advance!

David