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)
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.
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)Bolt Nut
Screw Driver
Nail Hammer
Col 1 Col 2 Col 3
Bolt Hammer Non-Match
Bolt Driver Match
Nail Driver Non-Match
SCREW DriveR Non-Match
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.