Formula question with Text

[JoinAZ]

Hi, I'm trying to create a formula that looks at a cell containing a sentence in another worksheet (called Working sheet). I want to copy that entire cell to a new worksheet if the sentence contains the word "license". I can get it to work only if just the word license shows up by itself but not if there are other words in the sentence.
Here's what I have so far.
=IF('working sheet'!D1="license",Sheet2!D1)

Thanks for your help.

 

[Dave R.]

try

=IF(ISNUMBER(SEARCH("license",'working sheet'!D1)),Sheet2!D1,"")

Hi, I'm trying to create a formula that looks at a cell containing a

sentence in another worksheet (called Working sheet). I want to copy that
entire cell to a new worksheet if the sentence contains the word "license".
I can get it to work only if just the word license shows up by itself but
not if there are other words in the sentence.

 

[Juan Sanchez]

Try

=IF(ISERROR(FIND("license",'working sheet'!D1)),"",Sheet2!
D1)

 

[Dave R.]

You're welcome, however for the record, your original post had

=IF('working sheet'!D1="license",Sheet2!D1)

which is why I used

Sheet2!D1

...rather than the more intuitive

'working sheet'!D1