data validation and drop down lists

L

LewR

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?
 
L

LewR

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Copying data from one workbook to another dependent on user select 1
Capturing dynamic ranges 10
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Drop down lists in seperate columns 5
drop down list 2
Data validation list using filtered range 3

Top