ISNUMBER

[Arceedee]

Im trying to identify cells that contain certain text using isnumber. I have
a column (M) that contains UK postcodes such as ST6 2JH, DE22 1BH, YO18 5DS
and many more etc. By using =ISNUMBER(SEARCH("YO",M2)) I am able to find the
YO in cell N2 but I need to expand it to find other postcodes as well, e.g.
DE. Column N should be able to state "True" when DE or YO is identified.

Thanks in advance.

 

[T. Valko]

Try it like this:

=OR(ISNUMBER(SEARCH({"YO","DE"},M2)))

 

[JBeaucaire]

You can list as many as you'd like inside of an OR listing:

=IF(OR(ISNUMBER(SEARCH("YO",N2)),ISNUMBER(SEARCH("DE",N2))),"TRUE")

Just slip in ans many ISNUMBER entries into the OR array as you'd like. If
any of them hit, you get a TRUE.