Newest ship date by vendor and item

Good morning

I am looking to find the newest ship date based on the vendor and the item. We have the same item shipped by different vendors, but I am looking for the individual item from each vendor. I have included a sample sheet. I can do it with one variable I believe, but I think it involves index and matching.

Any help would be appreciated.

Thanks
Brent