Need a formula to return an ARRAY prior to dynamic array functions - cannnot do it

[RamJag]

OK, I am new here, so go easy on me, please.

I have a matrix of data and I want a formula that will return an ARRAY where I need the formula to locate a single column (based on date) and then find all rows in that column that have a 1 in them, then return the contents of a different column for those rows. Gosh, its so hard to explain, especially when I've spent hours trying every conceivable thing to solve it.

The catch: It has to work pre-dynamic array functions. I can do this formula easily in O365 using the filter function:

=FILTER(E2:E9,FILTER(H2:AG9,H1:AG1=C11)=1) where H1:AG1 is a row with dates, and C11 is the date I'm looking for.

As I am sure my description is horrid, I've attached a simple workbook to explain Excel-Help-Array-PreDynamic.xlsx.

I hope someone can help with this!

Thanks so much.
Jim

[Fluff13]

How about in E13 dragged down

=IFERROR(INDEX($E$2:$E$9,AGGREGATE(15,6,(ROW($E$2:$E$9)-ROW($E$2)+1)/($H$2:$AG$9=1)/($H$1:$AG$1=$C$11),ROWS(E$13:E13))),"")

[RamJag]

Hi, Fluff13

Yeah, that will do it. THANKS! Honestly, I had seen reference to using Index and Aggregate in this manner during my search, but had
it stuck in my head that the single formula needed to return the entire array and that. However, for my purpose, dragging down the formula in this way works just fine.

So, THANKS AGAIN!

[Fluff13]

Glad to help & thanks for the feedback.