Hello,

I've had a look around the threads and can't find the answer I'm looking for (or more accurately can't apply the answers into the formula I need).

What I need to do is say:

If C2 contains "*Syd*", or "*UTS*", or "*Mel*"... (total of 11 possible text strings) then put a YES in this cell.

I've tried the IF(OR(ISERROR(FIND... but even when one of the possible text strings are present, the only result I get is "No", so I've got something wrong. Any help would be most appreciated.

Thank-you!