It looks like the error is on the OR sintaxis, it just checks TRUE/FALSE
conditions, so if you want to provide lists of values, you may do something
like this:
=IF(OR(C3="Squirel",C3 = "Rat"), "Animal", "Blank")

Hope this helps,
Miguel.

"duncan79" wrote:


I want to one validated entry from a list in a cell to auto fill another
from a seperate list of possibilities. my lists are 3d referenced

say i have as a dropdown option

Squirel
Rat
Carrot
Cucumber

on !Lists sheet B column

and

Animal
Vegetable

on !Lists sheet A column

I have tried several things and they just return #Value regardless of
whether i use a reference or the text itself eg:

=IF(OR(C3=(OR("Squirel", "Rat"))), "Animal", "Blank")

=IF(OR(C3=(OR("!ListsB1", "!ListsB2"))), "!ListsA1", "Blank")

I havent even tried entering the second 'vegetable' condition into the
formula yet and i have tried several arrangments of the formula. (with
or without the second OR)

Can anyone help??
If anyone can help with the second condition too that would be great.

Thanks

duncan


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