excel - Is there an Excel formula to find/match words in a range of cells

Question

I am looking for a formula to find/look for words in a range of cells. I have 4 words (DAY0,DAY3,DAY5,DAY9) that need to be in that range of cells. If not, it should state FALSE. See my example

Example of cells

标签： excelexcel-formula

Answer 1

修改范围并尝试：

=IFERROR(AND(MATCH("DAY0",$C$1:$C$4,0)>0,MATCH("DAY3",$C$1:$C$4,0)>0,MATCH("DAY5",$C$1:$C$4,0)>0,MATCH("DAY9",$C$1:$C$4,0)>0),FALSE)