How to pick-up data & populate across column?

[xlmaniac]

Dear All,
I do have the following sample data set spread across A1:D6
I would like to pick-up the Supplier Code against the latest PO date & populate the same across column E against one Article Code.
Pls help with the formula in column E which can deliver the said result.

Article Code	PO No	PO Date	Supplier Code	Supplier Code Against Last PO Date
1​	a	03-Jan​	10​	30​
1​	b	09-Jan​	20​	30​
1​	s	29-Jan​	30​	30​
1​	d	24-Jan​	30​	30​
1​	e	15-Jan​	30​	30​
2​	x	18-Jan​	40​	50​
2​	y	21-Jan​	50​	50​
2​	z	10-Jan​	50​	50​

​		​	​	​

 

[DanteAmor]

Dear DanteAmor,
Thanks a lot for your soultions.
It is yielding the desired result.
Thanks again!!

I'm glad to help you. Thanks for the feedback.

 

[Peter_SSs]

It is truly mesmerizing.
Thanks a lot for helping me again.
Regards

You are very welcome. Thanks for the follow-up.

I am on Excel 2010 and used your 2nd solution.

Could you update your Account details so any helpers will know for future questions?