Multiple Text Search Within Cell of Table

Hello all:

I'm seeing several possible solutions to this so far, but nothing quite close. I'm attempting to do a FIND with more than one characters within a string and which may not be in a particular order. Here's what I have so far, which is finding certain strings such as "POLY", "VINYL", and "NITRILE". Those all work ok; however, I'm trying to find "SYNTH" with "SM" or "SYNTH" with "MED", "SYNTH" "LG", etc. with wilcards to categorize those separately. I tried to use wildcards, but failing. Anything else falls under "OTHER" and the "SYNTH" rows are all showing up as "OTHER".

=IF(ISERROR(FIND("POLY",[@[Product Description]],1))=FALSE,"POLY",IF(ISERROR(FIND("*SYNTH*XL*",[@[Product Description]],1))=FALSE,"SYNTH XLG",IF(ISERROR(FIND("*SYNTH*LG*",[@[Product Description]],1))=FALSE,"SYNTH LG",IF(ISERROR(FIND("*SYNTH*SM*",[@[Product Description]],1))=FALSE,"SYNTH SM",IF(ISERROR(FIND("*SYNTH*MED*",[@[Product Description]],1))=FALSE,"SYNTH MED",IF(ISERROR(FIND("VINYL",[@[Product Description]],1))=FALSE,"VINYL",IF(ISERROR(FIND("NITR",[@[Product Description]],1))=FALSE,"NITRILE","OTHER")))))))

Thanks in advance! = )

I don't typically do this, but I was able to figure it out. I had to reconfigure the nested ifs, but also figure out the part with the SM, MED, LG descriptions and then work it into the rest of it. Took some finagling (sp?), but it worked out. I've attached a small sample as you suggested to help make a little more sense along with the revised formula. Thanks again!

Formula:

Please Login or Register  to view this content.

Here's the attachment:

Yes, thank you!