Checking values for multiple columns

[Figmint]

Hello,

Ive done a quick search here and been unable to find an exact answer for my question.
I may just be searching for the wrong keywords, I dont know.

What I am looking to do is check 2 columns of variables against 2 columns of correct data and then flag the incorrect data. This would be case sensitive as well.

Example:
Data (sheet 2)

Col 1 Col 2
Bolt Nut
Screw Driver
Nail Hammer
​

Variables (sheet 1)

Col 1 Col 2 Col 3
Bolt Hammer Non-Match
Bolt Driver Match
Nail Driver Non-Match
SCREW DriveR Non-Match​

I have tried with nested If/AND statements and I keep getting errors.
For my document I am checking about 25 constant data sets against a document of over 5000 rows, so doing it manualy is slow and anoying.

Any assistance would be appreciated.

 

[BarryL]

Thanks BarryL

It works so far, but last issue is when trying to sort the whole document the second set of variables point to diffrent lines:

Before sort
=IF(SUMPRODUCT((EXACT(F18,Data!$A$1:$A$68))*(EXACT(Variable!H18,Data!$B$1:$B$68)))>0,"match","Non-Match")

After sort
=IF(SUMPRODUCT((EXACT(F18,Rank!$A$1:$A$68))*(EXACT(Variable!H432,Data!$B$1:$B$68)))>0,"match","Non-Match")

Some reason sort isnt sorting by the value generated properly and then the formula gets messed up.

remove the Variable! before H18. so...

=IF(SUMPRODUCT((EXACT(F18,Data!$A$1:$A$68))*(EXACT(H18,Data!$B$1:$B$68)))>0,"match","Non-Match")

 

[Figmint]

Thanks, that worked

 

[BarryL]

Glad you got it working. thanks for the feedback