| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
