Well, you may use a different formula. Instead of OR, check this one:
=IF(ISNA(MATCH(C4,Lists!B1:B2,0)), "Animal", "not")
You can extend the list as much as you want.

Miguel.

"duncan79" wrote:


Brilliant that works thanks

is there any way of saying it in shorter hand by referencing ranges as
in

=IF(OR(C4 = Lists!B1:B2), "Animal", "not")

or do i have to enter each one by one??? i am working with a fair
amount of conitions so it would be to long winded to be entirely
practical


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=540255