Assuming your table is in A1:A3 I would try something like and the most recent will always be the last I would try something like:
=INDEX(B1:B3,MAX((A1:A3=A5)*ROW(A1:A3)))
as an array formula (confirm with ctrl+shift+enter)