Hello, I've been trying to work a formula, but I'm not even sure if
Lookup is the right one for this. Let's say I work in a pet shop and
I'd like to register the animals that come in.

I have three cells:
1. Pet
2. Color
3. Age

All three cells are drop down lists:
1. Dog, cat, bird, mouse
2. black, brown, gray, white
3. 1 to 3, 4 to 8, 9 to 15

Let's say, each time I choose in the first drop down list, whenever
I choose "Dog", I want that by default and automaticaly the other
two cells turn "brown", "4 to 8". And similarly, when I choose "cat"
they turn "grey", "9 to 15".

This because most of dogs and cats are that way (for the sake of
this example), but whenever a dog comes with different traits than
the deffaults, and I choose "Dog" and it goes "brown" and "4 to 8",
I want to still be able to modify it by clicking the same drop down
list and having the other options to click let's say "white" and "9 to

15". And the same if a cat with different traits from the default
arrives.

Is this possible in Excel? how could I do it?

Cheers!


--
cdwheel
------------------------------------------------------------------------
cdwheel's Profile: http://www.thecodecage.com/forumz/member.php?userid=193
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77966