Problem with IF(ISNUMBER(SEARCH

[olympiac]

Here is the scenario:
Cell A7 can contain the following values:
Code 1
Code 2
Code 3
Code 1;code 2;code 3
Code 1;code 2
Code 1;code 3
code 2;code 3

I need a formula that checks If the value in Cell D516 is contained in cell A7. If yes then I need the result (SHOW/HIDE) in cell D515

Eg:
Cell A7 = Code 1;code 2;code 3
Cell D516 = code 2
Cell D515 = SHOW

Cell A7 = Code 1;code 2
Cell D516 = code 3
Cell D515 = HIDE

My idea is to use something like
=IF(ISNUMBER(SEARCH($A$7,D516)),"SHOW","HIDE")
Unfortunately it doesn't work. Any alternative?

 

[VoG]

Try

=IF(ISNUMBER(SEARCH(D516,$A$7)),"SHOW","HIDE")

 

[olympiac]

Brilliant. It was so obvious.

Thanks

 

[T. Valko]

Here is the scenario:
Cell A7 can contain the following values:
Code 1
Code 2
Code 3
Code 1;code 2;code 3
Code 1;code 2
Code 1;code 3
code 2;code 3

I need a formula that checks If the value in Cell D516 is contained in cell A7. If yes then I need the result (SHOW/HIDE) in cell D515

Eg:
Cell A7 = Code 1;code 2;code 3
Cell D516 = code 2
Cell D515 = SHOW

Cell A7 = Code 1;code 2
Cell D516 = code 3
Cell D515 = HIDE

My idea is to use something like
=IF(ISNUMBER(SEARCH($A$7,D516)),"SHOW","HIDE")
Unfortunately it doesn't work. Any alternative?

Here's another one.

=IF(COUNTIF(A7,"*"&D516&"*"),"Show","Hide")