Hi Sunil

simply enter the following formula in the adjoing row, and copy down
Change the range to suit yourself.

=IF(ISNUMBER(MATCH(A1,$B$1:$B$7,0)),"Yes","No")


Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=36074