title: I have a dataframe which consists certain dates and respective values
body: <p>My challenge is that if any date is to be checked against a dates in the dataframe and it should be able to pull the respective value that which holds. I can show this to you</p>
  
  <pre><code>Date           Value
  4/6/2006    1,500,000
  4/6/2007    1,600,000
  4/6/2008    1,650,000
  4/6/2009    1,750,000
  4/6/2010    1,800,000
  4/6/2011    1,800,000
  4/6/2012    1,500,000
  4/6/2013    1,500,000
  4/6/2014    1,250,000
  4/6/2015    1,250,000
  4/6/2016    1,000,000
  4/6/2017    1,000,000
  4/6/2018    1,030,000
  </code></pre>
  
  <p>the date sometimes isn't exact same as the one in the field, it may vary and the value nearest to that date should be pulled. It should be in a loop.</p>