title: Excel Conditional Dynamic Data Validation
body: <p>I have a minor problem while playing with Excel. Here is the problem definition:</p>
  
  <p>I want conditional data validation for below table:</p>
  
  <pre><code>Column 1  Column 2
  Y         Res1
  Y         Res2
  N         Res3
  N         Res4
  Y         Res5
  </code></pre>
  
  <p>From above table, I need a cell dropdown(using data validation) with the list of values from Column 2 who has 'Y' value in Column 1. Is it possible? If yes, could you please help me out. Your help will be appreciated. </p>
  
  <p>Please note: I dont want to write Excel VBA for that, through VBA I am able to do so.. But requirement is to do with formulas.</p>