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 a certain value (if possible a simple formula stated in another worksheet). if cell A1 = value "test2" A2 should become another value / formula.

Can this be done dynamicly?

thanks.

3Pinter

Hi

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

Hope this helps.
Andy.

"3Pinter" <[email protected]> wrote in
message news:[email protected]...
>
> 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 a
> certain value (if possible a simple formula stated in another
> worksheet). if cell A1 = value "test2" A2 should become another value /
> formula.
>
> Can this be done dynamicly?
>
> thanks.
>
> 3Pinter
>
>
> --
> 3Pinter
> ------------------------------------------------------------------------
> 3Pinter's Profile:
> http://www.excelforum.com/member.php...o&userid=32623
> View this thread: http://www.excelforum.com/showthread...hreadid=527957
>

[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

3Pinter

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

Andy.

"3Pinter" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
> 3Pinter
>
>
> --
> 3Pinter
> ------------------------------------------------------------------------
> 3Pinter's Profile:
> http://www.excelforum.com/member.php...o&userid=32623
> View this thread: http://www.excelforum.com/showthread...hreadid=527957
>

[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

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

Andy.

"3Pinter" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> 3Pinter
> ------------------------------------------------------------------------
> 3Pinter's Profile:
> http://www.excelforum.com/member.php...o&userid=32623
> View this thread: http://www.excelforum.com/showthread...hreadid=527957
>

[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!!

3Pinter

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

Andy.

"3Pinter" <[email protected]> wrote in
message news:[email protected]...
>
> 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!!
>
> 3Pinter
>
>
> --
> 3Pinter
> ------------------------------------------------------------------------
> 3Pinter's Profile:
> http://www.excelforum.com/member.php...o&userid=32623
> View this thread: http://www.excelforum.com/showthread...hreadid=527957
>

[3Pinter]

ehh... I get an error???

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



Thanks

3Pinter