Thank u for ur time, still Im not able to find correct logic. See I have a
column in which there are alphanumerical in cell B10 to B20 (red 3, red4,
red6, red9, red10, red 15, red17, red18, red20, red23). I have cell in which
the input has given say cell A10 (red5) & I have a cell which will tell
whether input in A10 is present from the B10 to B20 or not say cell S10. If
Im putting the logic statement in cell S10 the logic is results in €śfalse€ť,
when I change the input in A10 as red4, which is present in cell B10 to b20
then also the answer is €śfalse€ť but it has to be €śtrue"
"Max" wrote:
Believe there was nothing wrong with the logic in the response earlier
Anyway, since you have revised your description
Put in S10:
=IF(A10="","",IF(COUNTIF(B10:B20,A10),TRUE,FALSE))
If the above settles it for you (it should),
pl press the YES button below to acknowledge
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"2226" wrote:
Thank u Max,
I have tried ur logic but it is not working, all results are "not found".
Let me explain once again my prob, in one cell I have an input say "C3" (say
cell no. A10), I need to check whethere that is present in a column(say cell
no. B10 to B20), if it is present then it should return true or else it
should return false. For this I need to write a function in the cell say
"cell no. S10"