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.