title: Look up a value in different df and take max date in r
body: <p>I have a DF, where I want to look up a value in another DF, but only taking the maximum Date of that observation.</p>
  <pre><code>DF_1 = as.data.frame(matrix(ncol = 3, nrow = 1))
  colnames(DF_1) = c(&quot;Financials AAA&quot;, &quot;Financials AA&quot;, &quot;Financials BBB&quot;)
  
  Date = as.Date(c(&quot;2022-07-29&quot;, &quot;2021-01-01&quot;, &quot;2020-01-01&quot;))
  Spreads_AAA = c(0.3, 0.5, 0.6)
  Spreads_AA = c(0.1,0.2,0.3)
  Spreads_BBB = c(1,2,3)
  Spreads = data.frame(Date,Spreads_AAA,Spreads_AA, Spreads_BBB)
  
  </code></pre>
  <p>So at the end I should get 0.3 for AAA, 0.1 for AA and 1 for BBB in the DF1 in the only row I have</p>
  <p>Thank you</p>