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?

Hi!

Use this as the source:

=INDIRECT(IF(A1="","other",A1))

Biff

"LewR" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

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.

You're welcome!

Biff

"LewR" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>