Excel Formula INDEX MATCH multiple search criteria

I'm trying to find a way to do an INDEX MATCH on multiple criteria but I am not having much luck.

I have 3 text entries that I want to flag the "Harmful" tag, which are "c001","c002" and "c003".. they will likely not be in a sorted list.

=IFERROR(IF(INDEX(F9:F34,MATCH("*C001*",$B$9:$B$34,0)),"Harmful",""),"")

Now this above works perfectly but every combination with nested IF statements and IF(OR formulae don't work for me!

Note that I am using wildcards because these codes are likely to form part of a longer text string.

Any advice/guidance will be greatly appreciated.

Kind Regards.