How To Populate Date Conditinally?

[xlmaniac]

Dear All,
I do have the following sample data set across A1:F4.

[TABLE="width: 479"]
<colgroup><col span="4"><col><col></colgroup><tbody>[TR]
[TD]Site[/TD]
[TD]SKU[/TD]
[TD]Qty[/TD]
[TD]Date[/TD]
[TD]Maximum Qty[/TD]
[TD]Maximum Qty Date[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]01-Oct[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]10-10-2019[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]10-Oct[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]10-10-2019[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]24-Oct[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]10-10-2019[/TD]
[/TR]
</tbody>[/TABLE]

In column E the formulae is as follows:-
E2=MAX(IF($A$2:$A$4=A2,IF($B$2:$B$4=B2,$C$2:$C$4)))

I am looking for formulae across Column F which can yield the desired result as given above.
Pls help.
Thanks

 

[Fluff]

How about
=INDEX($D$2:$D$4,MATCH(A2&"|"&B2&"|"&E2,INDEX($A$2:$A$4&"|"&$B$2:$B$4&"|"&$C$2:$C$4,0),0))

 

[xlmaniac]

How about
=INDEX($D$2:$D$4,MATCH(A2&"|"&B2&"|"&E2,INDEX($A$2:$A$4&"|"&$B$2:$B$4&"|"&$C$2:$C$4,0),0))

Thanks a lot Fluff for helping me out again with your mesmerising solution!!
Really appreciate the same!!
My sincere gratitude to you!!

 

[Fluff]

My pleasure & thanks for the feedback