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!
Bookmarks