| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation and further
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
Hi
You can use IF formulae in A2: =IF(A1="Test",16,IF(A1="Test2",20)) Hope this helps. Andy. "3Pinter" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
Have a look here, then - dependent lists:
http://www.contextures.com/xlDataVal02.html Andy. "3Pinter" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
How does Excel know that Tree brings up Beautiful? Is there a list
somewhere? Andy. "3Pinter" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation and further
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: http://www.excelforum.com/member.php...o&userid=32623 View this thread: http://www.excelforum.com/showthread...hreadid=527957 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
