Formula Request: Search Between Columns

SoudeDia

New member
Joined
Aug 25, 2013
Messages
9
Reaction score
0
Points
0
Location
Tampa Bay, FL
Excel Version(s)
16, 365
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.
 

Attachments

  • FormulaRequest_SearchBetweenColumns.xlsx
    8.6 KB · Views: 14

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try

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