I have the following formular with looks for any parts of the words food, lunch, packed and I want it to provide the message shown. It works fine if I only use one of the criteria but not with multiple. Can someone point me in the right direction or advise me on the formula?
There is a second part to this request, in that if it finds one of more of the criteria and there is a value in its corresponding cell in column F to hide the message?
=IF(COUNTIFS($C$32:$C$35,"*Food*",$C$32:$C$35,"*Lunch*",$C$32:$C$35,"*Packed*"),"Have Staff Been Included This","")
There is a second part to this request, in that if it finds one of more of the criteria and there is a value in its corresponding cell in column F to hide the message?
=IF(COUNTIFS($C$32:$C$35,"*Food*",$C$32:$C$35,"*Lunch*",$C$32:$C$35,"*Packed*"),"Have Staff Been Included This","")
