title: Drop-down dependent menus in Google Spreadsheets
body: <p>I am new to this formula milarky and have made a spreadsheet on Google sheets for my farm. I want to make the Herbicide(column G) drop down dependent on what is selected in column C.</p>
  
  <p>my requirements for each individual crop is listed on dropdown tab(colm M-V) </p>
  
  <p>(<a href="https://docs.google.com/spreadsheets/d/1wBaHVORL86C38FO1sRapxR3Ps9TuYfAFRzH12daN64k/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1wBaHVORL86C38FO1sRapxR3Ps9TuYfAFRzH12daN64k/edit?usp=sharing</a>) </p>
  
  <p>ps: any other ideas that anybody thinks would benifit on my sheet for me and my farm would be greatly appreciated</p>