Lookup with more than one criteria

Hi,  I have an Excel sheet with several transactions in different currencies and on different dates. In the next sheet I have an overview of all the different currencies on each day for a given peri...