I have the following formula in Range A8:A30-

=IF('Mix Check'!U8="","",'Mix Check'!U8&'Mix Check'!N8&'Mix Check'!
O8&'Mix Check'!P8&'Mix Check'!Q8&'Mix Check'!R8&'Mix Check'!S8&'Mix
Check'!T8)

This will produce a result something like: - '1 Day Sales Mix missing
Mon; Tue' etc etc

How can I check in AA1; if my value that is held within A1 (this will
show a value of one of Mon, Tue, Wed, Thur, Fri, Sat, Sun), appears
anywhere within the result in A8; A11;A14, If it does appear, return
0, if it doesn't Return 0?

I have different non-contiguous range I wish to check hence A8; A11;
A14 etc

Thanks