How can I use one cell to display another cell's value?
 

Here's the scenario: I've set up a drop down box with state names. If
Alabama is selected in A3, I want B3 to display another drop down box with
Mammogram, Diabetes, Mental Health, etc. There might be as many as 15 items
in the second drop down box. Then in C3, it should display text.

Is this possible? I've got the drops downs but the formulas act like
there's nothing in the previous cell with the drop down selection.

How can I use one cell to display another cell's value?
 

You need dependent dropdown lists.

See Debra's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 08:23:03 -0700, GingerSnapsToo
wrote:

Here's the scenario: I've set up a drop down box with state names. If
Alabama is selected in A3, I want B3 to display another drop down box with
Mammogram, Diabetes, Mental Health, etc. There might be as many as 15 items
in the second drop down box. Then in C3, it should display text.

Is this possible? I've got the drops downs but the formulas act like
there's nothing in the previous cell with the drop down selection.

How can I use one cell to display another cell's value?
 

Thank you, that was very helpful.

"Gord Dibben" wrote:

You need dependent dropdown lists.

See Debra's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 08:23:03 -0700, GingerSnapsToo
wrote:

Here's the scenario: I've set up a drop down box with state names. If
Alabama is selected in A3, I want B3 to display another drop down box with
Mammogram, Diabetes, Mental Health, etc. There might be as many as 15 items
in the second drop down box. Then in C3, it should display text.

Is this possible? I've got the drops downs but the formulas act like
there's nothing in the previous cell with the drop down selection.