View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joseph[_59_] Joseph[_59_] is offline
external usenet poster
 
Posts: 3
Default Create a dependent drop down list in Google Sheets in a wholecolumn not just one row

On Monday, April 22, 2019 at 10:16:49 AM UTC-5, Joseph wrote:
Hello everyone,

I really need some help trying to complete this task. After trying and investigating all over I can't manage to figure this out. What I'm trying to achieve is to obtain a list of options in a drop down list based on another list shown in a drop down list.I have successfully done it with the first entry,but it is not possible to drag this set up to the remaining cells below because once you select the 2nd drop down list in the row beneath the first,the populate list corresponds to the the first row populated list.
I've been watching youtube videos about this matter,but no lucking undestanding how to do this.

Thank you for your time.


Please see attached file example