title: google spreadsheet query to dropdown list
body: <p>I'm working on a google spreadsheet and have to do a dropdown list depending on some criteria.
  For example I have a DB page with :</p>
  
  <pre><code>|   A  |   B   |
  | name | price |
  | a    | 100   |
  | b    | 120   |
  | c    | 150   |
  </code></pre>
  
  <p>If I want to get a list of all item I know I can do it with the formula, going to data > validation and say the range <code>DB!A3:A999</code> as explained here : <a href="https://support.google.com/docs/answer/186103" rel="nofollow">https://support.google.com/docs/answer/186103</a></p>
  
  <p>Now I would like to add some possible filter for the user like min &amp; max price.</p>
  
  <p>I think I need to use the query formula like <code>=QUERY(DB!3:999, "SELECT A WHERE B&gt;=110 AND B&lt;=140")</code> but this is returning all correct result in all case under where I put the formula (1 row = 1 result). Is there a way to turn this query into a dropdown list ? or any other way to add criterias to the validation range ?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Here is a spreadsheet link if you want to test your solution before posting
  <a href="https://docs.google.com/spreadsheets/d/1mwgBla7DyIHio8eH3xr2w_EngvHcHIeTXwc43e7YwwU/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1mwgBla7DyIHio8eH3xr2w_EngvHcHIeTXwc43e7YwwU/edit?usp=sharing</a></p>