Modify formula to not execute if cell contains certain text

I have a formula that executes under the following circumstances (see attached spreadsheet)

B3 = "a string of text"
D3 = "Yes"
F3 = B3 if D3 = Yes

What I want to do is stope F3 executing if B3 contains a specific string of text

The attached spreadsheet may explain it more clearly

Try this formula for F3

=IF(AND(D3="Yes",COUNT(SEARCH({"FRAU401B","FRAU407B","REG415A","REG416A"},B3))=0),B3,"")

My reading of this was in F3

Please Login or Register  to view this content.

If correct then this modification of daddylonglegs' formula might be

Please Login or Register  to view this content.

or possibly using wildcards

Please Login or Register  to view this content.

If this applies to "FRAU40?B" or "REG41?A"
Or if only "FRAU401B","FRAU407B", "REG415A", "REG416A" are possible entries.

Hope this helps.

Try this,

H34. Must hit CONTROL+SHIFT+ENTER, rather than ENTER.

Please Login or Register  to view this content.

Then copy down.