Perform Lookup for Dropdown List

I am trying to get a Dropdown List that is currently pointing to a Dynamic Range to filter depending on the value in another Dynamic Range. I have attached a simple example of what I am working with.

In the example I would like to select the Yard in the Dropdown in A3 and when selecting the Rig in B3 I want it to only show the Rigs that are classified as Active.

The formula that I am using for the Named Range is =OFFSET(RigInfo!$D$2,,,COUNTA(RigInfo!$D:$D),1) and I can't figure out the additional information needed in the formula to only find "Active" in column F.