VLOOKUP with 3 conditions

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!

Try this:
=INDEX($D$1:$D$22,AGGREGATE(14,6,(($D$3:$D$22>=I2)*(D3:D22<=$J$2)*($C$3:$C$22="yes")*($B$3:$B$22="OK")*($A$3:$A$22=$F$10)*(ROW($D$3:$D$22))),1))

G10=SUMIFS(D3:D22,B3:B22,"oK",C3:C22,"yes",D3:D22,">="&I2,D3:D22,"<="&J2,$A$3:$A$22,F10)

Originally Posted by CARACALLA

G10=SUMIFS(D3:D22,B3:B22,"oK",C3:C22,"yes",D3:D22,">="&I2,D3:D22,"<="&J2,$A$3:$A$22,F10)

Brilliant! It worked! Thank you very much!

Originally Posted by Markulane

It didn't manage to make it work...

should work...

Thank you José Augusto!

Hello,

How can I improve the formula to show the latest date?

The conditions are: Condition 1 = OK; Condition 2 = Yes; The dates must be between 01/01/2020 and 01/02/2021. For Assistant will list two dates (01/07/2020 and 01/09/2020). How can I improve the formula to show the latest date? On this example is which is 01/09/2020?

Thank you

=AGGREGATE(14,6,D3:D22/((B3:B22="OK")*($C$3:$C$22="Yes")*($D$3:$D$22>=$I$2)*($D$3:$D$22<=$J$2)*($A$3:$A$22=F10)),1)

Originally Posted by davsth

=AGGREGATE(14,6,D3:D22/((B3:B22="OK")*($C$3:$C$22="Yes")*($D$3:$D$22>=$I$2)*($D$3:$D$22<=$J$2)*($A$3:$A$22=F10)),1)

Excellent! Thank you!