title: Formula in Excel to match a value in two columns with an occurence date of 24 hours difference
body: <p>I am trying to match products in two different tables by their product name and date/time. I'm looking to find a match between column A &amp; K if the date in column C occurred 24 hours BEFORE column L. </p>
  
  <p>I have attached a picture of the matches I'm looking for &amp; highlighted the ones that should result in a match. </p>
  
  <p><a href="https://i.stack.imgur.com/jXimA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jXimA.png" alt="picture here"></a></p>
  
  <p>thank you in advance for your help - this is far more advance than my knowledge of excel unfortunately, so I really appreciate the assistance.</p>