Simplifying IF(OR(A4=B2, A4=C2, A4=D2, .......... , A4=ZZ2), 0, "Error")

[phil123_123]

I've spent quite some time googling to find an to the following but failed (hard to get quite right search terms):

How to simplify the following formula:

Simplifying IF(OR(A4=B2, A4=C2, A4=D2, .......... , A4=ZZ2), 0, "Error")

To something of this style (though this doesn't work): IF(A4=B2:ZZ2, 0, "Error")

I should also mention that all of these cells contain strings.

Many thanks in advance for any help (and apologies if I am repeating a previous post).

 

[Special-K99]

Does this work?

=IF(COUNTIF(B2:ZZ2,A4)<>0,0,"Error")

 

[gaz_chops]

Try
=IF(COUNTIF(B2:ZZ2,A4)=0,"Error",0)

 

[phil123_123]

Thanks Special-K99 and gaz_chops for the prompt responses. Used an IF(COUNTIF()) statement within a few formulas in my excel spreadsheet and works brilliantly and elegantly. Red up a bit more about the countif function and will definetely be using it more frequently.

 

[gaz_chops]

You're welcome.