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
Bookmarks