Hello
I want to search for either parameters in a cell using the If(ISNUMBER(search(....
for example if a cell text contains either "sneakers" or "boots", the result should be "shoes"
as for the formula I'm using the result is false.
for example
Asics - Duo-Colored Sneakers =IF(ISNUMBER(SEARCH((OR("sneakers","boots")),A2)),"shoes","false")
the result is false
Asics - Duo-Colored Sneakers =IF(ISNUMBER(SEARCH((OR("sneakers","boots")),A2)),"shoes","false") the result is always false
Screen Shot 2015-11-17 at 4.22.33 PM.png
Kindly advise.
Bookmarks