One way...

=IF(AND(ISTEXT(A1),ISERROR(SEARCH("Already",Sheet1 !A1))),"x","")

--
Biff
Microsoft Excel MVP


"Chicago2Paris" wrote in message
...
I searched the board, but couldn't find an exact answer to my issue, so I'm
looking for some help.

I have a column that may contain text or may be blank.

I want to place an "x" on another sheet if:
1. There is text in the cell AND
2. The cell does not contain the word "Already" in the sentence

Thanks!