find/search

[osaben]

Looking to return an answer when text in a different cell contains the same text. I as using the below formula, but it does not seem to be working.

=IF(ISNUMBER(FIND(A62,Licenses)),"YES","NO")


NOTE,the actual text in A62 may not exactly equal "Licenses", but instead may contain that text along with other words as well.

I am using FIND because it do not want the search to be case sensitive.

What seems to be wrong with my formula?

Thanks in advance you your help.

 

[Twollaston]

Looking to return an answer when text in a different cell contains the same text. I as using the below formula, but it does not seem to be working.

=IF(ISNUMBER(FIND(A62,Licenses)),"YES","NO")


What seems to be wrong with my formula?

Use this it's working for lowercase and caps for me
=IF((SEARCH("Licenses",A62)>0),"YES","NO")
also, from your formula
you didn't have quotes around licenses and your arguements A62,"licenses" should be in opposite spots


=IF(ISNUMBER(FIND("Licenses",A62)),"YES","NO")
this one is case sensitive

 

[kweaver]

You need double quotes around the word Licenses.

=IF(ISNUMBER(FIND(A62,"Licenses")),"YES","NO")

 

[osaben]

Twollaston.

Thanks for your suggestion. That worked perfectly!

 

[osaben]

All:

=IF(ISNUMBER(FIND("Licenses",A62)),"YES","NO") works perfectly.

HOWEVER, sometimes. A62 has NO text in it at all -- if that is the case, I do not want anything to be returned. Is this possible?

Thanks again.

 

[Twollaston]

All:

=IF(ISNUMBER(FIND("Licenses",A62)),"YES","NO") works perfectly.

HOWEVER, sometimes. A62 has NO text in it at all -- if that is the case, I do not want anything to be returned. Is this possible?

Thanks again.

Happy to help you
=If(A62="","",IF(ISNUMBER(FIND("Licenses",A62)),"YES","NO"))

 

[osaben]

Happy to help you
=If(A62="","",IF(ISNUMBER(FIND("Licenses",A62)),"YES","NO"))

That's it! Thank you for your help and expertise!