Sounds like you could use some sort of VLOOKUP, and if it returns an error,
you would know the item was not in your list of pets.

=IF(ISERROR(VLOOKUP(B2,D1:D10,1,FALSE)),0,1)

Where D1:D10 is where your list is.
--
Best Regards,

Luke M


"LastPhilippe" wrote:

Hello,

example:
I have a row where can be the names of animals: cow, cat, dog, frog, ...
To analyse the content against some special values, eg. pets(cat, dog), I
need a function which returns true (or 1) and false (or 0):
is_in_set(b$2$;pets)
or
is_in_set(b$2$;(cat,dog))

Any idea?
--
LastPhilippe Johannes