checking celll in column
 

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


--
withblue
------------------------------------------------------------------------
withblue's Profile: http://www.excelforum.com/member.php...o&userid=23767
View this thread: http://www.excelforum.com/showthread...hreadid=374147

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


--
dfeld71
------------------------------------------------------------------------
dfeld71's Profile: http://www.excelforum.com/member.php...o&userid=21452
View this thread: http://www.excelforum.com/showthread...hreadid=374147

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


--
withblue
------------------------------------------------------------------------
withblue's Profile: http://www.excelforum.com/member.php...o&userid=23767
View this thread: http://www.excelforum.com/showthread...hreadid=374147

Will this work for you?


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


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=374147