Find value in rows (40 cells) and populate in separate page in order

Hi

have a selection of cells to indicate window sizes.

Screenshot 1(cells to populate) is the summary of many cells. We indicate how many window we require per job on screenshot 2(array of cells). Not these tables, cells etc is on same page. Issue is to search true values through 30 odd cells then populate them in 12 cells. I just want the ek13 value or name to populate this cell if the value in table ey13;ge26 is true in rows 15 to 26. Ive even tried to populate top to bottom on table then try a lookup function but the window type can constantly change then ill have blank cells on screenshot 1 table. Otherwise i can try multiple nested if eqautions yet if i have a true v alue then it will also reflect in next cell.

Please assist

Maybe something like this, with a helper row of formulas to allow filtering....

In your example workbook, I deleted everything from C3:O16 to allow room for the FILTER formula to create the returned table. Then I entered SUM formulas in Q2 to AW2, which are used by the FILTER formula in C3:

=FILTER(Q3:AW16,Q2:AW2<>0)

And that is pretty much everything that I did....

IF you have problems with the structure of your actual workbook, take out any sensitive data and fill in with dummy values (and what you want as a result) and post that copy.

When a formula spills, the cells that are filled by the spill show the formula in light grey. The upper-left cell is the only cell with the actual formula. Confusing, but it is what it is....