title: Create in-cell dropdown with filtered range
body: <p>I'm using Google Spreadsheet.</p>
  
  <p>To illustrate my problem, I use the range <code>A2:A8</code> for the data validation of <code>D2</code> and <code>E2</code>.</p>
  
  <p><img src="https://i.stack.imgur.com/NV52G.png" alt="enter image description here"></p>
  
  <p>But because in cell <code>D2</code>, you are supposed to select an animal only, I'd like to filter the range with <code>B2:B8</code>.</p>
  
  <p>What I've tried, is using my own formula which is : </p>
  
  <pre><code>=FILTER(A2:A8;IS("B2:B8";"ANIMAL"))
  </code></pre>
  
  <p>but this won't work and I cannot pick the "dropdown" option if I use custom formula.</p>
  
  <p>I've also tried my formula in my Range selection, but it's not valid. What is the right formula to use to have a dropdown with filtered data?</p>
  
  <p>Any thoughts?</p>