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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]space1[/TD]
[TD]manifold1[/TD]
[TD]valve1[/TD]
[TD]9/9/99[/TD]
[/TR]
[TR]
[TD]space1[/TD]
[TD]manifold1[/TD]
[TD]valve2[/TD]
[TD]9/8/99[/TD]
[/TR]
[TR]
[TD]space2[/TD]
[TD]manifold1[/TD]
[TD]valve1[/TD]
[TD]9/9/99[/TD]
[/TR]
[TR]
[TD]space2[/TD]
[TD]manifold1[/TD]
[TD]valve2[/TD]
[TD]unknown[/TD]
[/TR]
</tbody>[/TABLE]
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))