Array to pull two adjacent cells values based on date

[Nade85]

After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves attached to manifolds. See below for example.

space1	manifold1	valve1	9/9/99
space1	manifold1	valve2	9/8/99
space2	manifold1	valve1	9/9/99
space2	manifold1	valve2	unknown

<tbody>
</tbody>

I have gotten the array to function for filtering out the "unknown" lines and placing them in their own table. I cannot convert the array formula to handle dates older than (today()-720). Basically I want to create a list of all the manifolds by space that have at least one valve with a service date more than 2 years ago. Below is my formula as it stands right now. Cell D4 has the equation "=today()-720". Any assistance in how to change this formula would be much appreciated.

=INDEX(Inventory_Table, MATCH(0, COUNTIFS($H$3:$H3,Inventory_Table[SPACE], $I$3:$I3,Inventory_Table[MANIFOLD ID / EQUIP NO.])+IFERROR(NOT(SEARCH($D$4, Inventory_Table[REBUILD DATE])=1), 1)+0, 0), COLUMN(A2))

 

[Nade85]

Figured out a work around.

I set the cell that the array's Search function references ($D$4 in the above equation) to "Yes" and created a new column in the data Inventory_Table that returns either "Yes" or "No" using the following equation:

=IF(OR([@[REBUILD DATE]]<=(TODAY()-720),[@[REBUILD DATE]]="Unknown"),"Yes","No")

The array was then changed to match that and some cell realignment (aesthetics) so there are some minor differences other than just what pulls in the desired data.

=INDEX(Inventory_Table, MATCH(0, COUNTIFS($F$4:$F4,Inventory_Table[SPACE], $G$4:$G4,Inventory_Table[MANIFOLD ID / EQUIP NO.])+IFERROR(NOT(SEARCH($B$29, Inventory_Table[Overdue ?])=1), 1)+0, 0), COLUMN(A2))