Index Match formula for date range and other criteria

[TruffleOil]

Hi everyone

I have a set of data with different notification dates for several projects (some different projects have the same notification date) and different owners (table in A7 column, as a Source).
My goal is to filter and list all the projects that fall within a certain date range (column D3 and E3), and that belong to a specific owner (column E4, which is a dropdown menu for all owners).

Right now I have a formula that works for the date range criteria, which is show in column G6 and H6:
G6: =IFERROR(INDEX($B$8:$B$11, AGGREGATE(15,6,(ROW($B$8:$B$11)-ROW($B$8)+1)/($B$8:$B$11>=$D$3)/($B$8:$B$11<=$E$3),ROWS($G$6:G6))),"")

H6: =IFERROR(INDEX($A$8:$A$11, AGGREGATE(15,6,(ROW($B$8:$B$11)-ROW($B$8)+1)/($B$8:$B$11>=$D$3)/($B$8:$B$11<=$E$3),ROWS($G$6:H6))),"")

My problem is I don't know how to also add the criteria for owner filter. So, in this case it shows Projects A and C that fall within the April 2022 range. But Project A is owned by John and Project C is owned by Jeff. Now I only want to see the projects owned by John (column E4), so Project A in this case.
Could you please support and advice how to tweak the formula to include the owner criteria?

Thank you in advance!

 

[Fluff]

How about

=IFERROR(INDEX($B$8:$B$11, AGGREGATE(15,6,(ROW($B$8:$B$11)-ROW($B$8)+1)/($B$8:$B$11>=$D$3)/($B$8:$B$11<=$E$3)/($C$8:$C$11=$E$4),ROWS($G$6:G6))),"")

 

[TruffleOil]

It worked, thank you so much Fluff!!

 

[Fluff]

You're welcome & thanks for the feedback.