ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   dependent, multiple variable, drop down list (https://www.excelbanter.com/new-users-excel/449292-dependent-multiple-variable-drop-down-list.html)

narcosmurf September 25th 13 02:13 AM

dependent, multiple variable, drop down list
 
I am trying to setup a form that has several drop-down lists that update the subsequent drop down until a final result is listed.

To simplify it, I'll narrow this down, but the final build will have 15 options in first column, second would have 80 options per 1 option in first column, then about 10 in third per option in column 2, etc... So I couldn't do this with a simple IF statement.

Below is a simplified listing of information. If someone could send me in the right direction, where to look or what to look up, I would be appreciative. Searching for information on the web without understanding all the formulas for excel is next to impossible.

First drop down would list:
A
B
C

A is chosen, second drop down would list:
1
2
3

B is chosen, second drop down would list:
4
5
6

C is chosen, second drop down would list:
7
8
9

narcosmurf September 25th 13 06:27 AM

Delete this thread, found the answer in another thread once I posted this.

Claus Busch September 25th 13 06:45 AM

dependent, multiple variable, drop down list
 
Hi,

Am Wed, 25 Sep 2013 02:13:58 +0100 schrieb narcosmurf:

To simplify it, I'll narrow this down, but the final build will have 15
options in first column, second would have 80 options per 1 option in
first column, then about 10 in third per option in column 2, etc... So
I couldn't do this with a simple IF statement.


have a look:
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal15.html


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com