If a cell contains either pieces of text return Y else N

[JBC70]

Hi again - I thought I had this one sorted but can't seem to get it working without an error.

I'm looking for the following:

If cell A1 contains the string "NTB" or "N2B" anywhere within the cell text then return "Y" into B1 otherwise return "N" in B1.

Thank you again

 

[KRice]

Try:

=IF(OR(ISNUMBER(FIND({"NTB","N2B"},A1))),"Y","N")

...which is case sensitive. Use SEARCH instead of find if case sensitivity doesn't matter.

 

[JBC70]

Thank you !!

 

[KRice]

You're welcome...happy to help.