Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 25th 13, 02:13 AM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 2
Default 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

  #2   Report Post  
Old September 25th 13, 06:27 AM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 2
Default

Delete this thread, found the answer in another thread once I posted this.
  #3   Report Post  
Old September 25th 13, 06:45 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,566
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dependent drop down list yowzers Excel Worksheet Functions 1 December 18th 09 10:36 PM
DEPENDENT DROP DOWN LIST SSJ New Users to Excel 1 March 25th 08 12:56 AM
Create a drop down list dependent on selection from another list rosiep Excel Programming 2 March 30th 07 08:22 PM
Dependent drop-down list?? DocBrown Excel Worksheet Functions 4 July 21st 06 01:55 AM
Define drop-down results that are variable and dependent upon the. 33zenlane Excel Discussion (Misc queries) 4 December 13th 05 10:42 PM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017