in c1 enter:

=IF(COUNTIF(B:B,$A$1)0,2,"")




"anil" wrote in message
ups.com:

Hi all

I have a cell "A1" where i am giving my values and have an column "B"
of data, i want to check the entered data in the first cell is present
in the Data column , and if so 2 to be displayed in "C1"else
""(null),...

Thanks and Regards
Anil.Hungund