I would like to make my search formula dynamic based on VBA, or if there is any simpler solution... I have around 2000 text values in column A, in column B are formulas 
=OR(ISNUMBER(SEARCH($C$1,A1)),ISNUMBER(SEARCH($C$2,A1)),ISNUMBER(SEARCH($C$3,A1)))
for each A value to determine if there are any C column values.
For now there are only 3 C column values I would like to be able to add more C values or decrease them without having to change B formula.
I presume that count function in VBA to count C values and change formula based on that value, but I have no clue how to create that macro.

Also I think that deleting any C search values without changing B column formula would result in false positives or negetive values.

Dynamic search function.xlsx

Thanks.