validation and further

[3Pinter]

Hi,

I have a list, using validation and created a dropdown cell.

Is it possible to create somesort of a check:
cell A1 is the dropdown. If cell A1 value = "test" cell A2 should be
certain value (if possible a simple formula stated in anothe
worksheet). if cell A1 = value "test2" A2 should become another value
formula.

Can this be done dynamicly?

thanks.

3Pinte

 

[Guest]

Hi

You can use IF formulae in A2:
=IF(A1="Test",16,IF(A1="Test2",20))

Hope this helps.
Andy.

 

[3Pinter]

Yeah, an IF construction works but I was wondering if this can be done
dynamicly.

example of a somesort of a database:
1. test | value1 | etc
2. test2 | value2 | etc2
3. test3 | value3 | etc3

In my sheet:
validate dropdown in A1 uses colom of test, test2, test3.

What I want then is:
I choose in cell A1, dropdown, and select test2.
Then cell B1 should change to value2
And cell C1 shoudl change to etc2


can this be done? maybe this is a database related question??

Thanks

3Pinte

 

[Guest]

Have a look here, then - dependent lists:
http://www.contextures.com/xlDataVal02.html

Andy.

 

[3Pinter]

Andy,

Thanks for your reply that indeed looks great and almost what I'm
looking for.

Problem is: the article creates two dependent lists while I whould like
to have one dependent list and one cell which attaches a value (or
formula) which is a 'child' of the chosen dependent list-value.

Categorie:
1. apple
2. tree
3. pineapple

Sort
1. nice
2. beautiful
3. big

Categorie is a list. When I choose for example 2. tree --> cell B2
should automaticly become 2. beautiful.


Is this possible?

3Pinter

 

[Guest]

How does Excel know that Tree brings up Beautiful? Is there a list
somewhere?

Andy.

 

[3Pinter]

No that I think.

Please do look at this file, I think this explains it better.
http://www.fromthemill.nl/map1.xls


I hope you can help me, would be great!!

3Pinte

 

[Guest]

Try this:
=VLOOKUP(A3,var!A4:B6,2,FALSE)

Andy.

 

[3Pinter]

ehh... I get an error???

EDIT: I got it! working fine right now (had to remove the validation
ofcourse)

Thanks

3Pinter