Is it possible to use SEARCH and OR functions together in excel when searching the "filename"

[xcelnovice101]

I am trying to have a cell prepopulate based on the tab name which should be one of the following options:

"DB", "HC", "DB-HC", "HC-DB", "HC&DB" or "DB&HC"

Below is my formula in excel, not VBA and everything appears to be working except for the first section highlighted in red. I think it all comes down to using "&&" in the formula. I've tried "&" and that doesn't work either.

=IFERROR([COLOR=#ff0000]IF(SEARCH(OR("-","&&"),LEFT(MID(CELL("filename",M1),FIND("]",CELL("filename",M1))+1,255),5),1)>0[/COLOR],LEFT(MID(CELL("filename",M1),FIND("]",CELL("filename",M1))+1,255),5),LEFT(MID(CELL("filename",M1),FIND("]",CELL("filename",M1))+1,255),2)),LEFT(MID(CELL("filename",M1),FIND("]",CELL("filename",M1))+1,255),2))

 

[xcelnovice101]

I just tried the same formula but replaced "&&" with "+" and get the same results. When I go into the excel forumla bar on that section of the formula, excel provides the reults #VALUE! so I'm now thinking we can't do the OR Function in conjunction with the SEARCH function. Does anybody know is this is in fact the case?