It sounds like you are trying to see if entry in column b exists
anywhere in column a. If so
=if(not(iserror(match(b1,$a$1:$a$3,0))),"Break","N/A")
--
duane
------------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...o&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=466425