title: Excel Data Validation List using formula with filtering
body: <p>I have following workbook:</p>
  
  <p>Worksheet <strong>Accounts</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/9NLQd.png" alt="Accounts worksheet"></p>
  
  <p>Worksheet <strong>Posts</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/5R844.png" alt="Posts worksheet"></p>
  
  <p>I would like to know if it is possible to define Data Validation of type List to entire column <strong>B</strong> in sheet <strong>Posts</strong> using formula, so that Data Validation popup shows only Account <strong>Ids</strong> from <strong>Accounts</strong> sheet which <strong>Website</strong> column matches <strong>Website</strong> column of a selected row in <strong>Posts</strong> sheet and which have value <em>Active</em> in <strong>Status</strong> column?</p>
  
  <p>In SQL-ish or LINQ-ish words:</p>
  
  <blockquote>
    <p>SELECT Id FROM Accounts WHERE Website =
    @SelectedPostRow.Website AND Status = Active</p>
  </blockquote>
  
  <p>Marks on the second image shows which values should be shown in a drop-down.</p>