You need to be more consistent with your data. In your examples you
quote red 3 and red 15 (i.e. with spaces in them), but also red4, red5
etc (without spaces). I suspect this is what is causing you problems.

Hope this helps.

Pete

On Jan 5, 9:39*am, 2226 wrote:
Thank u for ur time, still I’m 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
I’m 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"- Hide quoted text -

- Show quoted text -