| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and drop down lists
All: I have problem with getting a drop down list to work. In cell A1 I have a Data Validation list that refers to a named range "directions". "directions has 5 rows, row 1 is blank, row 2 "north", row 3 "south" row 4 "east" and row 5 "west" in cell B1 I have another data validation list that uses the following: "INDIRECT(A1)", which will only select the values in the named range of either "north", "south", "east', or "west" what I want to do is have cell B1 refer to a named range "other" if row 1 (blank entry) is selected in cell A1, and refer to the other named ranges if their direction is chosen. Any sugestions? -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=522058 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation and drop down lists
Hi!
Use this as the source: =INDIRECT(IF(A1="","other",A1)) Biff "LewR" wrote in message ... All: I have problem with getting a drop down list to work. In cell A1 I have a Data Validation list that refers to a named range "directions". "directions has 5 rows, row 1 is blank, row 2 "north", row 3 "south" row 4 "east" and row 5 "west" in cell B1 I have another data validation list that uses the following: "INDIRECT(A1)", which will only select the values in the named range of either "north", "south", "east', or "west" what I want to do is have cell B1 refer to a named range "other" if row 1 (blank entry) is selected in cell A1, and refer to the other named ranges if their direction is chosen. Any sugestions? -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=522058 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation and drop down lists
Thanks, I knew that it would be a simple solution, but I am just learning rxcel and some times the simole things are the hardest. -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=522058 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation and drop down lists
You're welcome!
Biff "LewR" wrote in message ... Thanks, I knew that it would be a simple solution, but I am just learning rxcel and some times the simole things are the hardest. -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=522058 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation and Drop down lists. | Excel Worksheet Functions | |||
| Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
| data validation - Drop Down Lists | Excel Discussion (Misc queries) | |||
| Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
| Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
Linear Mode
