Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Drop Down list to an If Statement to another Drop Down list
Hello all,
I am trying to do something I can't quite figure out. I am trying to take a selection from a drop down list on one sheet, copy it to another sheet, then use that selection and an IF statement that will then control the drop down list I see. Confusing I am sure... So here is an example as best I can make it at this time. Real world Example: Sheet 1 A1 = Drop Down of OS (AIX, LINUX, WINDOWS) Sheet 2 A1 = Copy of the choice from Sheet 1 - A1 (=IF(LEN(TRIM('Sheet 1'!A1))0,TRIM('Sheet 1'!A1),"") ?? = If statement saying if AIX, then your drop down list is limited to Sheet 3 - A1:A5 A2 = Shows the drop down list utilizing Sheet 3 - A1:A5 Sheet 3 A1:A5 (Text Values) HELP PLEASE!!! I have seen the code from the IF statement on, but I can't get the IF statement to work with a drop down selection, it just shows me #VALUE. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Drop Down list to an If Statement to another Drop Down list
Hi Tyler,
Am Mon, 8 Apr 2013 17:18:35 +0000 schrieb Tyler B: Sheet 1 A1 = Drop Down of OS (AIX, LINUX, WINDOWS) Sheet 2 A1 = Copy of the choice from Sheet 1 - A1 (=IF(LEN(TRIM('Sheet 1'!A1))0,TRIM('Sheet 1'!A1),"") ?? = If statement saying if AIX, then your drop down list is limited to Sheet 3 - A1:A5 A2 = Shows the drop down list utilizing Sheet 3 - A1:A5 Sheet 3 A1:A5 (Text Values) name the range Sheet3 A1:A5 "AIX" Select Sheet2 A2 = Data = Data Validation = List = =Indirect(A1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Quote:
Thank you for the reply, this worked. However I realized i messed up in my example so have had to re-write it below. I can get the one to work, just trying to figure out how to do the many options that I need. Sheet 1 A1 = Drop Down of OS (AIX, Linux, Windows) Sheet 2 A1 = Copy of the choice from Sheet 1 - A1: =IF(LEN(TRIM('Sheet1'!A1))0,TRIM('Sheet1'!A1),"" ?? = If statement saying if blank, do nothing, if AIX (Linux or Windows), then have a drop down list that is limited to Sheet3 - B1:B5, C1:C5, or D1:D5 (Respectively) B2 = Shows the drop down list utilizing Sheet 3 - B1:B5, C1:C5, or D1:D5 Sheet 3 A1:A5 (List of OS) & B1:B5 (LIst of AIX - AIX Small, AIX Medium, AIX Large) C1:C5 (List of Linux - Linux Small, Linux Medium, Linux Large) D1:D5 (LIst of Windows - Windows Small, Windows Medium, Windows Large) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Drop Down list to an If Statement to another Drop Down list
Hi Tyler,
Am Tue, 9 Apr 2013 15:00:52 +0000 schrieb Tyler B: I can get the one to work, just trying to figure out how to do the many options that I need. Sheet 1 A1 = Drop Down of OS (AIX, Linux, Windows) Sheet 3 A1:A5 (List of OS) & B1:B5 (LIst of AIX - AIX Small, AIX Medium, AIX Large) C1:C5 (List of Linux - Linux Small, Linux Medium, Linux Large) D1:D5 (LIst of Windows - Windows Small, Windows Medium, Windows Large) please look he https://skydrive.live.com/#cid=9378A...121822A3%21191 for the workbook "Tyler" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional formula from a drop down list and If Statement | Excel Programming | |||
adding a drop down list to an If Statement? | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
If statement with a drop down list | Excel Discussion (Misc queries) | |||
Drop down list with an if statement | Excel Worksheet Functions |