IF function
I've got three columns in one worksheet with different codes:
Col A Col B Col C
91113 24 50
91114 25 50
I also have another three columns in a different worksheet with similar
information.
Col A Col B Col C
91113 24 50
91115 88 88
Can someone pls help me with the below IF function criteria
If the all codes in Col A, B & C in worksheet 1 = Col A, B & C in
worksheet 2 then label this "ok".
If only codes in Col A & B in worksheet 1 = Col A & B in worksheet 2
then label this "partial".
If codes in Col A & B in worksheet 1 does not equal Col A & B in
worksheet 2 then label this "check".
Thanks.
|