Trouble trying to find last match with multiple criteria.

Hello,

I am trying to find the last match value with multiple criteria. I have tried several formulas that I found online, but either had trouble getting them to work, or could not get them to work the way I wanted to.

The value of the last match I need to find is the Contact Date (ContactT[Contact Date]).
Criteria #1 is the Company Names must match.
Criteria #2 is the Sample Status must match the "Delivered" status.
The cell and column I am extracting the value to is on a separate table and separate page (LeadsT[Delivered]).

Basically, I am trying to find the last "Delivered" Date for each Company.


The current formula I have in the LeadsT[Delivered] column, is an Index/Match formula with multiple criteria. It works getting the first match, which I was satisfied with, prior to realizing that I needed the last match.
Another is a Lookup formula. It works getting the first match with multiple criteria, but not the last match like I need.
And another is two characters off from the second formula, which I did by mistake I think (it has one less set of parenthesis). It works getting the last match, but ignores the second criteria (Sample Status="Delivered").
All other formulas I tried, I wound up with errors.

The formulas are included in the attached workbook. For some reason, when I try to add them, it says I can't post any links without posting more.

Thank you so much for any help, please let me know if I need to add anything else!

Hi Glenn, thank you for responding. I'm sorry I didn't explain that well enough or if I made that too confusing.

I am expecting to find the last match for the Company and "Delivered" date, therefore, for Store #3 (Woodinville), I want it to retrieve the date of "7/25/2019" (the latest Delivery date), and NOT "4/25/2019" (the first Delivery date).

Thank you for taking the time to look at everything. Please let me know if there is anything else I should add or clear up. Thanks!

Caracalla, wow thank you so much! Those both definitely work. I really appreciate your help and taking the time out of your day to do so.

ProtonLeah, thank you for also helping and doing the same!

This forum is great Have a great day!

You are welcome

works also with aggregate