title: data validation based on adjacent cells in a google spreadsheet
body: <p>The sheet I am using is <a href="https://docs.google.com/spreadsheet/ccc?key=0As4zIxUmN7bjdDlQWjZodWJSaE5kMHFOM0pORzBjUHc" rel="nofollow noreferrer">here</a>.</p>
  
  <p>I want to take the validation in column F, Row 2, and apply it to all rows of column F based on the respective values in columns B and C for each row.</p>
  
  <p>E.g.  A2 = Pittsburgh, B2=Philadelphia, F2 is a dropdown for either "Pittsburgh" or "Philadelphia".   A116=CAROLINA, B116=PHILADELPHIA, then F116 should be a dropdown for either "CAROLINA", or "PHILADELPHIA".</p>
  
  <p>I found <a href="https://stackoverflow.com/questions/11696499/paste-data-validation-only-using-google-apps-script">this example script</a> that will copy just the validation, however I will need to add a counter to increment each source cell in the validation for each row that it applies to.</p>