title: Excel Style Combo Box in Google Sheets
body: <p>I have an issue regarding Google Sheets.</p>
  
  <p>I have a spreadsheet in Google docs that i have copied from an excel spreadsheet that I created. What I need to figure out how to do is make a combo box that that when I select an option in the list it changes the value of another cell from a 1 to 2 or 3 or 4 etc. </p>
  
  <p>I have this working in excel but cant seem to figure out how to do it in sheets.</p>
  
  <p>My question is, does any one know of a way to do this? Is it even possible?</p>