I have a list of Account Numbers and Order Dates, and another list of Account Numbers and Activity Dates. I need to find the Activity Date that is less than but as close as possible to the Order Date for each Account Number. Each account will not necessarily have an Activity Date, and should not return an approximate match if no exact match is present. In the attached screenshot, the green and red boxes in the attached screenshots are the values I am trying to isolate. Thank you for any assistance you can offer.
Capture.JPG
Bookmarks