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