Match mutliple values and then display text if found

I'm not sure how I could use an IF function since the I need a formula that will search every row for a match

As always, thanks for your help!

Here's another way, doesn't require CTRL+SHIFT+ENTER.....

=IF(SUMPRODUCT((Sheet1!B$1:B$9=B2)*(Sheet1!C$1:C$9=C2)*(Sheet1!D$1:D$9=D2)*(Sheet1!E$1:E$9=E2)* (Sheet1!F$1:F$9=F2)),"","X")