If Or famula for finding word in a sentance

[Closed]
Report
-
Hello,

Can anybody help to find ans for below question

if sentances are " HEDgroup people are in bench" "evals making count" "nothing in MIL"

i want the fomula if HED is there in sentance i wanted Apple or i wanted Berry.

i tried with the below formula but its not working

=IF(OR(SEARCH(AP89="MIL",AP89="MY",AP89="HED",AP89="evals",AP89="PTB",AP89="chat",AP89="live",AP89="higer"),"Apple","Berry"))