Find certain text in a column and return statement
 

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.


--
TelecomAuditor


------------------------------------------------------------------------
TelecomAuditor's Profile: http://www.excelforum.com/member.php...o&userid=26525
View this thread: http://www.excelforum.com/showthread...hreadid=397943

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


TelecomAuditor Wrote:
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
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=397943

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=397943

Thank you, Cutter! It worked beautifully.


--
TelecomAuditor


------------------------------------------------------------------------
TelecomAuditor's Profile: http://www.excelforum.com/member.php...o&userid=26525
View this thread: http://www.excelforum.com/showthread...hreadid=397943

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=397943