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?