combining formula

[handri]

Good day

Here is my code

=IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No")

The result is in C6 (empty cell). When I put a number in A6 (empty cell).
Then the empty cell C6 show the result. The substring is in B3.

How to combine formula with my code above

thank you

 

[mohadin]

Hi
Do you mean that if the contents of A6 is present in the b4 the C6 is yes?

 

[mohadin]

Ok if so

=IF(ISNUMBER(SEARCH(A6,B3)), "Yes", "No")

 

[Fluff]

Not sure if I've understood correctly, but maybe
=IF(A6="","",IF(ISNUMBER(SEARCH(B$3,B6)), "Yes", "No"))

 

[handri]

Ok if so

=IF(ISNUMBER(SEARCH(A6,B3)), "Yes", "No")

thank sir, for your help.

 

[handri]

Not sure if I've understood correctly, but maybe
=IF(A6="","",IF(ISNUMBER(SEARCH(B$3,B6)), "Yes", "No"))

thank you sir. This is exactly i want. Here is my code

=IF(A6="","",IF(ISNUMBER(SEARCH(B$3,A6)), "Yes", "No")). Works. Just replace the B6 with A6.

How can i made formula for data validation in C6 for "No" result. I want to made error stop alert. In C6 cell.

thank sir

 

[Fluff]

You would need to put the data validation in A6 not C6.