View Single Post
  #3   Report Post  
Old September 25th 13, 06:45 AM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,651
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