| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell coloring according to the other cell's value | Excel Worksheet Functions | |||
| How do I enter a formula in a cell that changes per another cell's | Excel Worksheet Functions | |||
| Display another Cell's DATE value Here | Excel Discussion (Misc queries) | |||
| How do I get a cell to flash depending on another cell's value? | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Linear Mode
