Hello,

This is likely quite an easy task but I am having difficulty figuring it out and would really appreciate assistance.

I have multiple columns (i.e. A through J) that contain specific numbers (i.e. 62, 31, 44, 55, 78). I would like to check ALL of these columns for certain numbers (i.e. just 62 AND/OR 62 and 31) and have either a 0 or 1 populate into another cell.

Example:

IF A:J contains 62 AND/OR 31 AND/OR 44 THEN Cell K equals 1 else 0.

How should this statement be written? How do I go about writing this code?

THANK YOU!!