User Defined Function - Adjustment (IF/AND?)

Hi,

I have the following extract from a UDF:

Please Login or Register  to view this content.

Which Looks in a cell and if it contains these words (pyrodur or pyrostop) then class it as "Fire"

However I need to break this down a further level to:
If it contains (Pyrodur and CS) or (Pyrostop and CS) then its "Fire CS"
If it contains (Pyrodur and Stock) or (Pyrostop and Stock) then its "Fire Stock"

The field to look in would be displayed like this:
Pyrostop EI30-10 15mm CS -----------The result would need to be displayed as "Fire CS"
Pyrodur EW30-201 10mm CS -----------The result would need to be displayed as "Fire CS"
Pyrostop EI30-10 15mm Stock -----------The result would need to be displayed as "Fire Stock"
Pyrodur EW30-201 10mm Stock -----------The result would need to be displayed as "Fire Stock"

Importantly I can not get it to search just "CS" or "Stock" as there are other non fire products that fall into this.

Can an AND function be added to the code above e.g. Like *Pyrostop* AND *CS* but both must be present (not just pyrostop or CS)

Any suggestions?

Paul

thanks, this worked - just need to amend it alittle

Sometime "Stock" is written as:
Stock
STOCK
Stk

Can the line below:
Like "*STOCK" Then

Be changed to include all different ways of saying "stock"?

Hi,

Sorry i wasnt clear. Our database for the various products displays stock as either: STOCK, Stock, Stk so ideally i would like one code that will take all three into consideration - is this possible?