This formula will _only_ put a "Yes" on orders "On Hold" and still not
"Closed".

=CHOOSE(1+SUMPRODUCT((A7=$A$3:$A$7)*(($C$3:$C$7="O n
Hold")+($C$3:$C$7="Closed")*3)),"","Yes","","","")

Hope it can be of use
Ola Sandström


Also see encl. zip-file:
http://www.excelforum.com/attachment...tid=3572&stc=1


+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3572 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=384573