Compare data A&B to data C&D

[former_member1197052]

I have 2 variables - VR1 & VR2 and want to return a value that shows matches between V_MAN & V_MIN.

The idea is to data load the mismatches

i.e.

VR1 = A V_MIN = A

VR2 = B V_MAX = D

So I know VR1 is = V_MIN do I need to do a variable saying if VR1 - V_MIN then "MATCH" else "NO" or if VR1 =V_MAX "SECOND MATCH" else "NO" or if VR2=V_MIN then "MATCH" else "NO and so on. The variable doesn't seem to like my syntax. Can I do this all in one variable to leave to columns of results?

[nscheaffer]

Can you provide a screenshot of what you have tried? Sample data with the expected result would be helpful too.

Also, if you could edit your question for clarity that would help as well. For example, the title of the question is "Compare data A&B to data C&D" yet there is no mention of "C" in the body of the question. You have "if VR1 - V_MIN then...". Do you mean "if VR1 = V_MIN then..."?

Noel