Hi All.
I have scanned several excel sites and for some reason cannot find an answer to my query. For some reason I always get array formulas thrown at me, which I have used once before but seem hard to apply in this case.
(I am using ISNUMBER SEARCH as I am trying to search for part text matches. However, there are generally TWO columns that need to have part text matches. I am steering away from array formulas as 1. the two columns vary wildly and and will do so also in each IF formula I create, and 2. the two columns can be on different spreadsheets. In the example though, in order to simplify I list them as if they are on the same sheet as both each other and the column I have the formula in. I don't have problems with a single ISNUMBER SEARCH formula, but for some reason am struggling to link them together.)
What I am trying to say in the below formula is: IF cell O2 includes somewhere in it the text "CVSDGS" AND cell A2 contains somewhere in it the text "Apple" then return the value "1 year", otherwise return BLANK. I tried the *AND to link them as it was suggested by excel to complete the formula (instead of just AND). While the formula doesn't return an error, it unfortunately returns BLANK for all values, both TRUE and FALSE.
=IF(ISNUMBER(SEARCH(O2,"*CVSDGS*"))*AND(ISNUMBER(SEARCH(B2,"Apple*"))),"1 year","")
Please HELP!!
Bookmarks