retrieve value from list based on 2 criteria incl date

Hi
Try to use
=ÍNDICE(Table_resources[Role];AGREGAR(14;6;(Table_resources[Resource]=[@Resource])*(Table_resources[Per Datum]<=[@Period])*LIN(Table_resources[Date+Rec]);1)-1)

Formula:

=ÍNDICE(Table_resources[Role];AGREGAR(14;6;(Table_resources[Resource]=[@Resource])*(Table_resources[Per Datum]<=[@Period])*LIN(Table_resources[Date+Rec]);1)-1)

Please note: the formula is not an array formula, ie don´t use CSE.
See the file Example2.xlsx