Hi,

I have the A1 which is either a cable, an adapter, a mouse or a notebook. I'd like to get the category "accessory" if it's a cable/adapter or a mouse.
I've tried the following formula but it doesn't work:

=IF(OR(ISNUMBER(SEARCH("cable","adapter","mouse";a1)));"accessory";"")

Any tip what the issue is? May be the separator settings?

Thanks,
Divi