software

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

Can this be done dynamicly?

thanks.

3Pinter--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: www.excelforum.com/member.php...oamp;userid=32623
View this thread: www.excelforum.com/showthread...hreadid=527957Hi

You can use IF formulae in A2:
=IF(A1=quot;Testquot;,16,IF(A1=quot;Test2quot;,20))

Hope this helps.
Andy.

quot;3Pinterquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have a list, using validation and created a dropdown cell.
gt;
gt; Is it possible to create somesort of a check:
gt; cell A1 is the dropdown. If cell A1 value = quot;testquot; cell A2 should be a
gt; certain value (if possible a simple formula stated in another
gt; worksheet). if cell A1 = value quot;test2quot; A2 should become another value /
gt; formula.
gt;
gt; Can this be done dynamicly?
gt;
gt; thanks.
gt;
gt; 3Pinter
gt;
gt;
gt; --
gt; 3Pinter
gt; ------------------------------------------------------------------------
gt; 3Pinter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32623
gt; View this thread: www.excelforum.com/showthread...hreadid=527957
gt;

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 etc2can this be done? maybe this is a database related question??

Thanks

3Pinter--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: www.excelforum.com/member.php...oamp;userid=32623
View this thread: www.excelforum.com/showthread...hreadid=527957Have a look here, then - dependent lists:
www.contextures.com/xlDataVal02.html

Andy.

quot;3Pinterquot; gt; wrote in
message ...
gt;
gt; Yeah, an IF construction works but I was wondering if this can be done,
gt; dynamicly.
gt;
gt; example of a somesort of a database:
gt; 1. test | value1 | etc
gt; 2. test2 | value2 | etc2
gt; 3. test3 | value3 | etc3
gt;
gt; In my sheet:
gt; validate dropdown in A1 uses colom of test, test2, test3.
gt;
gt; What I want then is:
gt; I choose in cell A1, dropdown, and select test2.
gt; Then cell B1 should change to value2
gt; And cell C1 shoudl change to etc2
gt;
gt;
gt; can this be done? maybe this is a database related question??
gt;
gt; Thanks
gt;
gt; 3Pinter
gt;
gt;
gt; --
gt; 3Pinter
gt; ------------------------------------------------------------------------
gt; 3Pinter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32623
gt; View this thread: www.excelforum.com/showthread...hreadid=527957
gt;

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 --gt; cell B2
should automaticly become 2. beautiful.Is this possible?

3Pinter--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: www.excelforum.com/member.php...oamp;userid=32623
View this thread: www.excelforum.com/showthread...hreadid=527957How does Excel know that Tree brings up Beautiful? Is there a list
somewhere?

Andy.

quot;3Pinterquot; gt; wrote in
message ...
gt;
gt; Andy,
gt;
gt; Thanks for your reply that indeed looks great and almost what I'm
gt; looking for.
gt;
gt; Problem is: the article creates two dependent lists while I whould like
gt; to have one dependent list and one cell which attaches a value (or
gt; formula) which is a 'child' of the chosen dependent list-value.
gt;
gt; Categorie:
gt; 1. apple
gt; 2. tree
gt; 3. pineapple
gt;
gt; Sort
gt; 1. nice
gt; 2. beautiful
gt; 3. big
gt;
gt; Categorie is a list. When I choose for example 2. tree --gt; cell B2
gt; should automaticly become 2. beautiful.
gt;
gt;
gt; Is this possible?
gt;
gt; 3Pinter
gt;
gt;
gt; --
gt; 3Pinter
gt; ------------------------------------------------------------------------
gt; 3Pinter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32623
gt; View this thread: www.excelforum.com/showthread...hreadid=527957
gt;

No that I think.

Please do look at this file, I think this explains it better.
www.fromthemill.nl/map1.xlsI hope you can help me, would be great!!

3Pinter--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: www.excelforum.com/member.php...oamp;userid=32623
View this thread: www.excelforum.com/showthread...hreadid=527957Try this:
=VLOOKUP(A3,var!A4:B6,2,FALSE)

Andy.

quot;3Pinterquot; gt; wrote in
message ...
gt;
gt; No that I think.
gt;
gt; Please do look at this file, I think this explains it better.
gt; www.fromthemill.nl/map1.xls
gt;
gt;
gt; I hope you can help me, would be great!!
gt;
gt; 3Pinter
gt;
gt;
gt; --
gt; 3Pinter
gt; ------------------------------------------------------------------------
gt; 3Pinter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32623
gt; View this thread: www.excelforum.com/showthread...hreadid=527957
gt;

ehh... I get an error???

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

Thanks

3Pinter--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: www.excelforum.com/member.php...oamp;userid=32623
View this thread: www.excelforum.com/showthread...hreadid=527957