title: Excel 2007: Data Validation list with filtered data
body: <p>I would like to have a Validation List in cell D5 on Sheet1. The items in this list should be dynamically based on a table on Sheet2, but I only need the ones where Column2 is TRUE. Below is an example of my table on Sheet2:</p>
  
  <pre><code>Column1 | Column2
  Item1   | TRUE
  Item2   | TRUE
  Item3   | FALSE
  Item4   | TRUE
  </code></pre>
  
  <p>Based on the tabel above the Validation List in cell D5 on Sheet1 should only contain Item1, Item2 and Item4. Is this somehow possible (preferably without using VBA)? </p>
  
  <p>I know I can create dynamic Named Ranges, but I don't know how to filter them, based on another column.</p>