Returning Max Date from Another Sheet with Conditions
I am trying to gather the max date from a row on another sheet if that row has a matching cell to one on the current sheet. Below is a screenshot of the current sheet. I am trying to fill the Last Action Date cell if the Originating WO# cell matches the one on the other sheet.
I would like the formula to choose the latest date (from between Sent, Date Conf, Shipped, Received) on the other sheet if the WO numbers match.
I've tried a few combinations of Index, Match, Max, and Collect but can't seem to get the right formula.