Can someone tell me why this formula always returns no unless I put the WHOLE search string?

[spyrule]

This is the formula I'm attempting to use (which, I have used in the past and no issues):

=IF(ISNUMBER(SEARCH("Sport Slotted - GM - 126.62092SL","Slotted")), "Yes", "No")

This Always returns NO unless I put the whole search string as "Sport Slotted - GM - 126.62092SL", which defeats the whole point of this search.

 

[Eric W]

You have the parameters reversed. Try:

=IF(ISNUMBER(SEARCH("Slotted","Sport Slotted - GM - 126.62092SL")), "Yes", "No")

 

[spyrule]

NVM, Solved it.

Had the SEARCH terms backwards. I was thinking SEARCH(TEXT,WHAT TO SEARCH FOR), turns out its the opposite!

 

[Eric W]

Glad you got it sorted. I always try to remember SEARCH("needle", "haystack"). It's a little tricky since different languages do it differently. In fact, InStr in VBA has the parameters the opposite way. Frustrating!