Okay. I am trying to determine why this formula is not working. (or if it's just not going to work at all)
=IF(ISNUMBER(SEARCH("*facebook*",AM6:DO6)),"Facebook",IF(ISNUMBER(SEARCH("*bing*",AM6:DO6)),"Bing","Other"))
In cells AM6:D06, there are several cells that may contain bing or FB, embeded in a URL string... or neither. I want the formula to yield bing, FB or "other".
I ran this and it works, but only returns "other", will not find FB or bing. This formula is runinng in column A.
Last edited by nik1703; 05-26-2015 at 12:14 PM.
Search will never work, it searches in a string
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Sure it will. But, not in the formula syntax that the OP has tried.Originally Posted by mehmetcik
You would have to do something like this:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH("facebook",AM6:DO6))),"Facebook",IF(SUMPRODUCT(--ISNUMBER(SEARCH("bing",AM6:DO6))),"Bing","Other"))
However, using COUNTIF is more efficient:
=IF(COUNTIF(AM6:DO6,"*facebook*"),"Facebook",IF(COUNTIF(AM6:DO6,"*bing*"),"Bing","Other"))
But, could there be BOTH Facebook and Bing in the cells? If so, which ever one you test for first is the one that will be the result of the formula.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks