Conditional Text

[arifanmol]

using search or if or whatever alternative formula, I want that if B column contains Patel the result yes should be displayed in D column

but if the same cell contain Patel and Native, then the resultant text in D Column should be No plz check the file and give some solution

 

[ETAF]

try
=IF(AND(ISNUMBER(SEARCH("patel",B5,1)),ISNUMBER(SEARCH("Native",B5,1))),"No",IF(ISNUMBER(SEARCH("patel",B5,1)),"Yes",""))

 

[bosco_yip]

Or,

In E5, formula copied down:

=IF(B5<>"", IF(AND(ISNUMBER(SEARCH({"patel","native"},B5))),"No","Yes"),"")

 

[arifanmol]

I checked but it shows yes in all active columns

 

[bosco_yip]

I checked but it shows yes in all active columns

Then, use

=IF(B5<>"", IF(AND(ISNUMBER(SEARCH({"patel","native"},B5))),"No","Yes"),"")

or,

=IF(B5<>"", IF(ISERR(SEARCH("patel",B5)*SEARCH("native",B5)),"Yes","No"),"")

 

[arifanmol]

thanks a lot but if the text does not contain PATEL OR NATIVE then also it should display NO only
plz do the needful

 

[bosco_yip]

thanks a lot but if the text does not contain PATEL OR NATIVE then also it should display NO only
plz do the needful

Please be noted that all answers based on the Post #1 attached file.

Any addition question different from that will become a new question.

Ae per the forum rule: "one post one question".

You should need post a new thread for your new question.

This post is closed.