QUOTE=Elkar]Try this:

=IF(ISERROR(SEARCH("TS",B9)),"N","Y")&IF(ISERROR(S EARCH("TS",C9)),"N","Y")

HTH,
Elkar
[/color]

I verified and this is what I needed. Could you do me one favor and
explain to me what this formula means. Explain the process of the
formula. Thanks so much. This has saved alot of time and now I can
finish up the charts and begin all the forecast verification metrics. My
boss is going to be happy. Sweet!!!!!


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=552484