Identify mutiple Strings Within a String of Text

[maic15]

Hi,
I have 8 strings (rules) of text that need to be compared to a string of data in a cell.
For Example, data: 30,AH,EQ,MC,P2,PT,RF,S2,SN,T,ZM,ZN,

Rule: P2,S2,EQ
Result: 1 - which means it exists

So, I have a thousand records similiar to the one above.
Here are my eight rules:
Rule 1:P2,S2,EQ
Rule 2:P3,S3,EQ
Rule 3:P4,S6,ES,IC2
Rule 4:P3,S6,ET,IC1
Rule 5:P5,S6,ET,IC2
Rule 6:P3,S5,EQ
Rule 7:O
Rule 8:P

 

[PA HS Teacher]

Can more than one rule be true at a time?

If so what would the results look like?

Is is possible to have each component for each rule in a different cell? (instead of all in the same cell)

 

[PA HS Teacher]

How about something along the lines of the following:
=ISNUMBER(FIND(B$1,$A6)+FIND(B$2,$A6)+FIND(B$3,$A6)+FIND(B$4,$A6))*B5

Book1
	A	B	C	D	E	F	G	H	I
1		P2	P3	P4	P3	P5	P3	O	P
2		S2	S3	S6	S6	S6	S5
3		EQ	EQ	ES	ES	ET	EQ
4				IC2	IC1	IC2
5		Rule 1	Rule 2	Rule 3	Rule 4	Rule 5	Rule 6	Rule 7	Rule 8
6	30,AH,EQ,MC,P2,PT,RF,S2,SN,T,ZM,ZN,	1	0	0	0	0	0	0	8
Sheet2

 

[maic15]

The cell can have mutiple results