title: how to conditionally match in excel
body: <p>I've got two data sets: Data-A and Data-B.</p>
  
  <p><strong>Data-A</strong></p>
  
  <pre><code>A   B   C   D   Start_Date  End_Date
  N   C   P   1   23-05-2015  27-05-2015
  N   C   K   1   30-05-2015  07-06-2015
  N   C   Ke  1   09-06-2015  28-06-2015
  N   C   Ch  1   14-07-2015  25-07-2015
  N   C   Th  1   29-06-2015  13-07-2015
  N   C   Po  2   23-05-2015  27-05-2015
  N   C   Kan 2   30-05-2015  08-06-2015
  </code></pre>
  
  <p><strong>Data-B</strong></p>
  
  <pre><code>X       D     Date              A   B   C
  444     1   09-07-2015          
  455     1   20-07-2015          
  1542    1   28-06-2015          
  2321    1   21-07-2015          
  2744    1   01-07-2015          
  7455    2   25-05-2015          
  12454   2   02-06-2015          
  18568   2   24-05-2015          
  28329   2   03-06-2015          
  28661   2   31-05-2015          
  </code></pre>
  
  <p>Values is data-Bare missing and I need to fill them using conditional index matching/vlookup such that column D(Data-B) is matched along with <code>Date(Data-B)</code> such that <code>Start Date&lt;= Date &lt;=End Date.</code> </p>
  
  <p><strong>Desired Output:</strong> </p>
  
  <pre><code>X       D     Date              A   B   C
  444     1   09-07-2015          N   C  Th
  455     1   20-07-2015          N   C  Ch
  1542    1   28-06-2015          N   C  Ke
  2321    1   21-07-2015          N   C  Ch
  2744    1   01-07-2015          N   C  Th
  7455    2   25-05-2015          N   C  Po
  12454   2   02-06-2015          N   C  Kan
  18568   2   24-05-2015          N   C  Po
  28329   2   03-06-2015          N   C  Kan
  28661   2   31-05-2015          N   C  Kan
  </code></pre>