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