Or try this in A12 without helper column (and copy down)
Formula: copy to clipboard 
=IFERROR(INDEX(Trusts!$A$1:$A$26,IFERROR(1/AGGREGATE(14,6,1/(((Trusts!$B$2:$B$26=Search!$B$3)+(Trusts!$C$2:$C$26=Search!$B$3)+(Trusts!$D$2:$D$26=Search!$B$3)+(Trusts!$E$2:$E$26=Search!$B$3)>0)*((Trusts!$F$2:$F$26=Search!$B$7)+(Trusts!$G$2:$G$26=Search!$B$7)+(Trusts!$H$2:$H$26=Search!$B$7)+(Trusts!$I$2:$I$26=Search!$B$7)>0)*ROW($A$2:$A$26)),ROW(A1)),""),1),"")