How to determine whether a list contains a specific value?

[Guest]

Does anyone have any suggestions on how to determine whether a list contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric

 

[PCLIVE]

One way:

=IF(COUNTIF(A1:A10,4)>0,1,0)

HTH,
Paul

 

[Guest]

If you mean is 3 (B1) in column A

=IF(countif(A:A,B1)>0,1,0)

 

[PCLIVE]

I forgot to mention...in my example I used the value 4 instead of 3. See
toppers formula which references the value in B1.
=IF(COUNTIF(A:A,B1)>0,1,0)

 

[Guest]

Thank everyone very much for suggestions
Eric