View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GingerSnapsToo GingerSnapsToo is offline
external usenet poster
 
Posts: 5
Default 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.