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