Find certain text in a column and return statement

[TelecomAuditor]

I need help writing a formula that says if column AH (for example),
contains the text "schedule AK", then display a statement such as "not
found in contract".

The cells will have about 29 characters and this text appears at the
very end.

I'm sure this is pretty simple for someone out there, but I've banged
my head against the wall researching this. Seems that VLOOKUP and such
only applies to the first column.

 

[Morrigan]

=IF(FIND("schedule AK",AH1),"not found in contract","")

 

[Cutter]

Try this:
=IF(COUNTIF(AH:AH,"*schedule AK")>0,"not found in contract","")

 

[TelecomAuditor]

Thank you, Cutter! It worked beautifully.

 

[Cutter]

You're very welcome. Thanks for letting me know.