Which function to check any value existed withing a list?

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

Hi Eric:

COUNTIF() will work for you.

Let's say we have a set of values in column A, say A1 thru A100. In B1 we
insert the value we would like to check. In B2 enter:

=(COUNTIF(A1:A100,B1)>0) which will return TRUE if B1 is in the list
--
Gary's Student


"Eric" wrote:

> 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