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