Don't know if its possible in Excel

[cdwheel]

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 t

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

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

Cheers

 

[Jacob Skaria]

Let us say you have the below information in Sheet2 Range("A1:C3")

Column A to C
Row1 Dog,brown,4 to 8
Row2 Bird,black,1 to 3
Row3 Mouse,gray, 9 to 15

In Sheet1.
Set Datavalidation for Col A as list and set Range as Sheet2:A:A
Set Datavalidation for Col B as list and set Range as Sheet2:B:B
Set Datavalidation for Col C as list and set Range as Sheet2:C:B

Set formula in Sheet1 B
=IF(ISNA(MATCH(A1,Sheet2!A$1:A$3,0))=TRUE,"",INDEX(Sheet2!A$1:C$3,MATCH(A1,Sheet2!A$1:A$3,0),2))

Set formula in Sheet1 C1
=IF(ISNA(MATCH(A1,Sheet2!A$1:A$3,0))=TRUE,"",INDEX(Sheet2!A$1:C$3,MATCH(A1,Sheet2!A$1:A$3,0),3))


If this post helps click Yes

 

[cdwheel]

wow, this is kind of advances for me. Is there any tutorial where thi
is explained in detail?

Thanks you, cheers

 

[Jarek Kujawa]

look here:

http://www.cpearson.com/Excel/TablesAndLookups.aspx

 

[Jacob Skaria]

Dear

You can check out
http://www.mrexcel.com/articles/excel-vlookup-index-match.php

If this post helps click Yes