Formula to find if a number exists in a range of cells?

[LaurenJez]

Hello. I am using the below formula to find if a number (1 to 9) exists in a cell. The formula works, but what I really want is a formula that checks if a number (1 to 9) exists in a range of cells. Can anyone help with this?

Current formula that works: =IF(COUNT(FIND({1,2,3,4,5,6,7,8,9},O2))>0, "Yes", "No")

What I want but is not working: =IF(COUNT(FIND({1,2,3,4,5,6,7,8,9},O2:AB2))>0, "Yes", "No")

 

[LaurenJez]

@ LaurenJez: Your original range formula from Post #1 needs a slight modification to work (and being confirmed using Ctrl Shift Enter, not just Enter)

=IF(COUNT(FIND({1;2;3;4;5;6;7;8;9},O2:AB2))>0,"Yes","No")

Thank you, that worked! Do you happen to know if the formula can be further tweaked to find the digits 1 through 9 (as prescribed in the formula) but exclude factoring in a certain value; the value being "32EN"?

 

[Tetra201]

See if the following updated formula works for you:

=IF(COUNT(FIND({1;2;3;4;5;6;7;8;9},SUBSTITUTE(O2:AB2,"32EN","")))>0,"Yes","No")