Ok...So what solution did you go with?

"Sai" wrote in message
...
I sloved it. found the solution from one of the posts.

thanks.

"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.