Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get drop-down lists as results of =IF?
I have a spreadsheet in which I already have column for drop-down lists.
What I need to know, is how do I make an IF statement that will read from the previous drop-down list and then give a new drop-down list of categories for the result of the previous list. Or simply, how do I get an =IF to return a drop-down list as a result? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get drop-down lists as results of =IF?
See if this helps:
http://contextures.com/xlDataVal02.html Biff "Vyr" wrote in message ... I have a spreadsheet in which I already have column for drop-down lists. What I need to know, is how do I make an IF statement that will read from the previous drop-down list and then give a new drop-down list of categories for the result of the previous list. Or simply, how do I get an =IF to return a drop-down list as a result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
Setting up conditional drop down lists in Excel 2003? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
Drop Down Menu and multiple results | Excel Discussion (Misc queries) |