On Fri, 30 Dec 2005 23:56:02 -0800, "Eric"
wrote:

Does it have a single function to perform the similar task?
Given Lists {1,2,3,4,5,6,7,8,9}
Given number {2,3,7}
Condition: If any given number equals to any last 3 small integers, such as
{1,2,3} in this case, then TRUE.
2 is TRUE
3 is TRUE
7 is FALSE
Does anyone have any idea?
Thank you
Eric

list = the range where your numbers 1..9 are listed.

Your test number is in A14.

The following formula will do what you specify:

=SUMPRODUCT(-(SMALL(list,{1,2,3})=A14))<0


--ron