Which function to check any value existed withing a list?

E

Eric

Does anyone know which function to perform checking any value within a list?
such as
a list {1,2,3,4,5,6,7,8,9}
a value {4}
then return true
Thank you
Eric
 
C

Cutter

With your values in A1:A10 and your value to search for (4) in B1 tr
this:

=COUNTIF(A1:A10,B1)>0

This will return TRUE if there is a 4 (or any other value you put i
B1) in the list and FALSE if that value is not in the list
 
Top