=--ISNUMBER(MATCH(A1,B1:B10,0))


--
Regards,

Peo Sjoblom



"Sai" wrote in message
...
I am looking for a number in a column and the result I want is either 0 or
1.

if number is there i want 1 and if not 0.

I am trying with vlookup function and it is not working.

Can anybody help please.

Regards
sai.