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

[GingerSnapsToo]

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.

 

[Gord Dibben]

You need dependent dropdown lists.

See Debra's site for instructions.

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


Gord Dibben MS Excel MVP

 

[GingerSnapsToo]

Thank you, that was very helpful.

You need dependent dropdown lists.

See Debra's site for instructions.

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


Gord Dibben MS Excel MVP