Compare a data value from a sheet to a matrix in another sheet and return values

Is this what you mean?

Formula:

=IFERROR(INDEX(Sheet2!$A$2:$A$9,INDEX(MATCH(IF($B2="Any","",$B2)&IF($C2="Any","",$C2)&IF($D2="Any","",$D2)&IF($E2="Any","",$E2),IF($B2="Any","",Sheet2!$B$2:$B$9)&IF($C2="Any","",Sheet2!$C$2:$C$9)&IF($D2="Any","",Sheet2!$D$2:$D$9)&IF($E2="Any","",Sheet2!$E$2:$E$9),0),0)),"No Matrix Assigned")