title: vlookup: lookup_value as date range
body: <p>Following Situation:</p>
  
  <p>Sheet 1 provides a date range in two cells:</p>
  
  <pre><code>Beginning____End
  
  1.2013______2.2013
  
  2.2013______3.2013...
  </code></pre>
  
  <p>Sheet 2 provides specific dates and values</p>
  
  <pre><code>3.1.2013_____500$
  
  5.2.2013_____700$...
  </code></pre>
  
  <p>What I want to do now is insert the Values from Sheet 2 next to the right date ranges in Sheet 1. Please note that there is only one date (and thus one value) for each date range. </p>
  
  <pre><code>1.2013___ 2.2013___500$
  
  2.2013___ 3.2013___700$
  </code></pre>
  
  <p>Usually in such a situation I would use Vlookup and match the dates, but that doesn't work since I would have to put a value range as lookup_value.</p>
  
  <p>I would be very thankful for your help. This problem seems so easy but I can't seem to figure out a solution! I tried to apply some solutions for similar problems I found here and on other websites but I haven't found a solution yet.</p>
  
  <p>Thanks and best regards!</p>