checking celll in column

[withblue]

Hi
I need help
I want to look for a cell in column if we find the cell in the column “ the value of the cell” write 1 if not write 0
For example – I have A1 cell which have inside number I want to check if that number in the rang of C1;C100 if true 1 false 0
I do it like that =IF(C3=sheet1!C3:C16;1;0) but it doesn’t work cuz it check in all the column not cell by cell in the column
Thnx

[dfeld71]

Try this:

=IF(ISNUMBER(MATCH(A1,C2:C100,0)),1,0)

A1 is the cell that holds the number you want to look up
C2:C100 is the range you want to look in.

HTH

[withblue]

thank you
but sorry it dosn't work as i want
any way thnx for trying helping me

[BenjieLop]

Will this work for you?


=if(iserror(vlookup(A1,C1:C100,1,0)),0,1)


Regards.