IF Statement to check ALL columns for certain numbers

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!!

It worked! I have one more question though: What do I do if I have close to 150 different numbers to consider? Would it work if I listed the numbers on a separate sheet and then in your statement

=IF(COUNTIF(A1:J1,Sheet2!A1:A150),"1","0")


I tried the above and it doesn't seem to work.

THANK YOU!!!!!! You have saved me a great deal of time and effort

It worked! I have one more question though: What do I do if I have close to 150 different numbers to consider? Would it work if I listed the numbers on a separate sheet and then in your statement

=IF(COUNTIF(A1:J1,Sheet2!A1:A150),"1","0")


I tried the above and it doesn't seem to work.

THANK YOU!!!!!! You have saved me a great deal of time and effort

That looks like it works, I can't thank you enough! you are a life saver!