Hello all, this is my first post so I'm looking forward to being a part of such a strong community.
Here's my question:
I have one worksheet with a list of unique line items as indicated by a unique string. I am trying to make one of these columns reflect the closest date in the future corresponding to each item in a separate worksheet. The second sheet has many of the items listed multiple times with different dates. I would like a function that can compare the unique ID in the first column of the first sheet to the range of IDs in the second sheet, then select the nearest future date from the dates corresponding to that ID in the date column and return that.
I have attached a workbook with a mockup of the data. In reference to this document, I need a way to get the nearest future date from column E in the first worksheet to populate the "Date of next closest Task" column in the second worksheet corresponding to the ID of the date.
Ex Wksht Next Date.xlsx
I have a tried a MIN(IF()) function where MIN(IF(AND("Unique ID" = "ID", "Unique Date" >= TODAY()),"Unique Date"), "") but can not get it to work.
If any other information would help, please let me know. Thank you!