=IF(ISNA(MATCH(B4,D4:D8)),"","X")

is, I think, what you want.

Gaz


--
gazornenplat
------------------------------------------------------------------------
gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494
View this thread: http://www.excelforum.com/showthread...hreadid=380928