Nested IF + OR

[amp7394]

I am trying to get the formula that says "IF this cell contains this OR that" however there are 3 conditions.

Here is an example of a cell:

PLT-NA-NA|CIG-NA-NA|GLD-NCORP-A|BSC-NCORP-A I have the first part of the formula: =IF(SUM(COUNTIF(A26,"*"&{"PLT-NCORP","PLT-CORP"}&"*")),"PLT","GLD") However, there is a third condition. If PLT-NA-NA, and GLD-NA-NA, then the value should be NA. How would I add this third part to the formula?

<tbody>
</tbody>

 

[Special-K99]

=if(sum(countif(A26,"*"&{"plt-na-na","gld-na-na"}&"*")),"na",if(sum(countif(A26,"*"&{"plt-ncorp","plt-corp"}&"*")),"plt","gld"))

or even

=LOOKUP(ISNUMBER(SEARCH("PLT-NCORP",A26))*1+ISNUMBER(SEARCH("PLT-CORP",A26))*1+ISNUMBER(SEARCH("PLT-NA-NA",a26))*2+ISNUMBER(SEARCH("GLD-NA-NA",a26))*2,{0,1,2,3},{"GLD","PLT","NA"})