to compare if cell b1 is in range a1:a100

=countif($a$1:$a$100,b1)

will return a number greater than 0 if it occurs in that rang

--
MDubbelboe
-----------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633
View this thread: http://www.excelforum.com/showthread.php?threadid=56222