Don't know if its possible in Excel
 

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

Don't know if its possible in Excel
 

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 B1
=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
--------------
Jacob Skaria

Don't know if its possible in Excel
 

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

Thanks you, 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

Don't know if its possible in Excel
 

look he

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


U¿ytkownik "cdwheel" napisa³ w wiadomo¶ci
...

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

Thanks you, 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

Don't know if its possible in Excel
 

Dear

You can check out
http://www.mrexcel.com/articles/exce...ndex-match.php

If this post helps click Yes
--------------
Jacob Skaria


"cdwheel" wrote:


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

Thanks you, 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