Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |