Problem with index match formula with multiple criteria s - help

[vba_newbie83]

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