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 
Please Login or Register  to view this content.
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.