How to determine whether a list contains a specific value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top