Problem with index match formula with multiple criteria s - help

Hi,


I work in financial services calculating fees and i am looking for a formula which will allow me to pick up daily prices based on product and date. The catch is my data doesn't include weekends, which means if it's not available the price will be the last reported price for the product

I tried to use an INDEX Match formula with two matches but doesn't seem to work

Attached is my spreadsheet. In the Queries tab is my data set, there are four products, with dates and prices and my formula is on the Calculations tab in column D and it's coming up with #REF which means it doesn't work.

=INDEX(DailyNAVs[aum_NAV],MATCH([@Date],DailyNAVs[DateValue],1),MATCH(Calculations!$I$3,DailyNAVs[aum_ISIN],1))

Hope someone can assist

thanks

Without a helper column you need to use an array formula to get the results you are looking for...

Please Login or Register  to view this content.

Enter the formula using Ctrl+Shift+Enter to get the array brackets {} around the formula.