If you just want to return true/false:

=AND(LEFT(J22,4)="bank",OR(J21="*** deleted ***",J21="*** created ***"))
or
=AND(LEFT(J22,4)="bank",OR(J21={"*** deleted ***","*** created ***"}))

You could use =find() or =search() if you wanted, but =left(,4) maybe easier to
understand.

wrote:

Hi,

Think I'm nearly there with my requirement but can't seem to get it
correct and into one formula!!

Basically need to look for where "*** Created ***" or "*** Deleted
***" appears within column J and Column G contains "Bank Details".
I've worked this formula out as per below:
=IF(AND(G21="Bank Details"),(OR(J21="*** Deleted ***",J21="*** Created
***")),)

However, I also need to have another IF statement in this formula for
if the above isn't appearing but the first four letters of column J
contains "Bank" then again show True. On it's own this formula would
do this:
=IF(FIND("Bank",J22)=1,TRUE,FALSE)

How do I basically combine this into one formula? This would be for
each row so obviously my example is just using the row underneath. In
summary:
- If entry in column J = *** Created *** OR = *** Deleted *** AND
entry in column G = "Bank Details" then put true.
- If first 4 characters within column J's entry = "Bank" then put
true

ELSE:
FALSE

Appreciate any help.

Thanks, Al.

--

Dave Peterson