In another post, a formula was given that was meant to help search and insert an entry if the date associated with the entry was less than the date on another sheet. The formula was as follows:
=IF( INDEX([LargerSheet!*Range with Dates*], MATCH( IF([SmallerSheet!*First Date in Range*]<[LargerSheet!*First Date in Range], [SmallerSheet!*Range with Dates]), [SmallerSheet!*Range with Dates*],0) )>0,1,"")
However, this did not quite work as desired. I am wondering if it might just be that my problem is slightly different. Essentially what I would like to do is, for a given entry in the SmallerSheet, check the dates associated with multiple objects in the LargerSheet and return the most recent date from the LargerSheet only if Most Recent Date < SmallerSheet Date. I think what the formula above is doing right now is checking if the SmallerSheet date is more recent than at least one of the dates on the LargerSheet, which results in the statement always being true because each SmallerSheet entry has multiple entries associated with it in the LargerSheet going very far back in time. Is this an easy fix?