title: Excel or Power Query: Merge/Lookup Closest Previous Date
body: <p>everyone:</p>
  <p>I have a table with these dates:</p>
  <p><a href="https://i.stack.imgur.com/eBHtl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eBHtl.png" alt="enter image description here" /></a></p>
  <p>I have another table with a list of dates and owners:</p>
  <p><a href="https://i.stack.imgur.com/LzXAm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LzXAm.png" alt="enter image description here" /></a></p>
  <p>I need to merge/join these two tables so that the transaction dates are matched up with the closest previous start date so that it looks like this:</p>
  <p><a href="https://i.stack.imgur.com/WPCfL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WPCfL.png" alt="enter image description here" /></a></p>
  <p>I tried using XLOOKUP with &quot;-1&quot; but that was a problem because XLOOKUP retrieved the first record for transaction date 4/16/2017 (which has 2 matches) and I couldn't merge on Power Query since there are no exact date matches. Is there another way?</p>
  <p>Thank you.</p>