Retrieve values in another workbook based on conditions (No VBA)

Hi,

I'm looking for a formula (Non-VBA) to retrieve specific values in a row based on 2 conditions. Formula on one workbook retrieves values in another workbook.
Please have a look at the example sheet I've made.

Thanks already for your help !!!
Bart