Thread: IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
missk missk is offline
external usenet poster
 
Posts: 17
Default 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.