Try this:

=IF(ISNUMBER(MATCH(A1,C2:C100,0)),1,0)

A1 is the cell that holds the number you want to look up
C2:C100 is the range you want to look in.

HTH


--
dfeld71
------------------------------------------------------------------------
dfeld71's Profile: http://www.excelforum.com/member.php...o&userid=21452
View this thread: http://www.excelforum.com/showthread...hreadid=374147