Contains condition with multiple IF/OR

[Balajibenz]

Hi Can someone help me with below with formula or VBA code.

I have string in column T and I need below to be done in column AK.

If string in column T contains 07X OR 18X then publish Yes in "AK". If column "T" has 08X OR 04X OR 07A the publish NO in "AK". else publish as Others. Thank you in advance.

07X,18X - Yes
08X,04X,07A - NO
Remaining - Others

 

[afonsomira]

Hello,

Try this formula, paste on cell "AK1": =IF(ISNUMBER(FIND("07X",T1,1)),"YES",IF(ISNUMBER(FIND("18X",T1,1)),"YES",IF(ISNUMBER(FIND("08X",T1,1)),"NO",IF(ISNUMBER(FIND("04X",T1,1)),"NO",IF(ISNUMBER(FIND("07A",T1,1)),"NO","OTHERS")))))

 

[Peter_SSs]

If you wanted one a bit shorter try

=IF(COUNT(SEARCH({"07X","18X"},T2)),"YES",IF(COUNT(SEARCH({"08X","04X","07A"},T2)),"NO","OTHERS"))

With your version of Excel you may need to confirm the formula with Ctrl+Shift+Enter, not just Enter