I would like to build on my previous thread called "How to enter date associated with last number greater than zero or last zero in row ", which was solved with the formulas is column B7:B21 & C7:C21. I would now like to pull the latest date using the Product Class. I've tried this with an Index Match function in C26:C30 but can only get #N/A as the result. It should look like C35:C39.
Thank you for any support and help.
Bookmarks