Extract data from table based on criteria applied to multiple columns

Hi everydody!

I have been struggling with this for some days and do not know how to solve it.
I need to create an automatic form where the next information is pulled from the the table. I habe several Project ID s but I need to bring the data for each project separate. The conditions to bring the information is that "Status" should be empty and "Reachable BU" should habe a date.

The ideal solution would be the table below in the file.

Thank you in advance for any help you can give me.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer

Take a look. All formulae are similar to this array formula:

=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$31=$C$33,IF($D$2:$D$31="",IF($F$2:$F$31>0,ROW($A$2:$A$31)))),ROWS($1:1))),"")

I have assumed that C33 should read S1007 and not 1007. Please let me know more information about coding if this was not a mistake by you.

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

Yes. Added. I changed C31, as a test, to exclude it from the list...

Upload a sample sheet.

You have removed the formulae. Please repost with them in place.

I got it (eventually) on the earlier sheet. It took me ages to spot that you had added an extra column... that caused confusion!!