Hi,
try

=if(COUNTIF(a122:a457,"Error")0,"Error","")

"Michelle Thompson" wrote:

I am trying to use an IF statement to look for text in range of cells but
cannot get it to return the value I want I think because I'm searching for
text not a value. If any cell in a column contains the text "Error" I want
the cell I'm in to also read "Error". Here's the formula I have but it won't
work: =IF(OR(A122:A457="Error"),"Error",""). Any suggestions?