VLOOKUP with 3 conditions

[Markulane]

Hello,

I need to find a solution for the following problem.

It must find a date, between the interval I2 to J2, has to be OK in the condition 1 and Yes in the condition 2. For instance, for category = Assistant, the result must be 30/07/2020.

Thank you so much!