Cell contain multiple text

[Shahuru]

Hi I need assistance to build a formula for the below scenario,

BB,DN = HB

BB,DN,LN = FB

If cell A1 contains " BB,DN " I want the result to go B1 as " HB" and if cell A1 contains " BB,DN,LN" results to be in B1 as "FB"


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]BB,DN,LN,
[/TD]
[TD]FB
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BB,DN
[/TD]
[TD]HB
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Ok, how about
=IF(SUMPRODUCT(COUNTIF(A1,{"*LN*","*DN*","*BB*","*WN*","*LQ*","*BR*"}))=6,"AI",IF(SUMPRODUCT(COUNTIF(A1,{"*LN*","*DN*","*BB*"}))=3,"FB",IF(SUMPRODUCT(COUNTIF(A1,{"*DN*","*BB*"}))=2,"HB","")))