Get the latest date in two different tables and return the corresponding value

I’m trying to get the latest date in two different tables and return the corresponding value in excel.

This is what I would want it to be like:

I’m new at excel so I’ve just been looking all over the internet for a solution but cant find anything.

>Solution :

Posted an an Answer, as confirmed by OP its working for them:

Try either of the one:

• Formula used in cell A6

=@CHOOSECOLS(SORT(VSTACK(A1:B4,D1:E4),1,-1),2)

Or,

• Formula used in cell B6

=INDEX(SORT(VSTACK(A1:B4,D1:E4),1,-1),1,2)

• Formula used in cell D6

=TAKE(SORT(VSTACK(A1:B4,D1:E4),1,-1),1,-1)