Formula question with Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try

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


JoinAZ said:
Hi, I'm trying to create a formula that looks at a cell containing a
Click to expand...
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.
 
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
 
Back
Top