Formula Request: Search Between Columns

[SoudeDia]

I am looking for a formula to accomplish the following:

The search needs to search column 3 for the numbers in column "Included" and "Excluded"
The columns have more than 10k lines
The search is anywhere in column 3

Thank you in advance for any help.

[Bob Phillips]

Try

=IF(COUNTIF(C:C,"*"&A6&"*"),"Included",IF(COUNTIF(C:C,"*"&B6&"*"),"Excluded","Not Found"))

[SoudeDia]

Try

=IF(COUNTIF(C:C,"*"&A6&"*"),"Included",IF(COUNTIF(C:C,"*"&B6&"*"),"Excluded","Not Found"))

Thank you so very much.