Maybe

=IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),0,1)

Vaya con Dios,
Chuck, CABGx3



"Sai" wrote:

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.