title: Dynamic drop-down lists in Google Sheets
body: <p>i want to know how to make dynamic drop down list in Google Sheets, e.g I have a list of continents in "Continent" column (data validation applied) and want to validate the next column with only countries that fall on previous selected continent.  <a href="https://docs.google.com/spreadsheets/d/1ycKBsHBRjVExPztN_VFj9q1P2i7KVmWmGnVx_uhivPc/edit?usp=sharing" rel="nofollow noreferrer">Example sheet</a></p>
  
  <p>It would be helpful to solve this without script.
  If it required script please explain in detail.</p>