microsoft excel – How to get a last value of column that is not blank and match with a cell in google sheet?


How to get a last value of column that is not blank and match with a cell in google sheet?

For example: value of cell is “David”.
Column A has names of students.
Column B has the dates.
I need to get last date if I enter a name of student.
I was trying use LOOKUP function like
=LOOKUP(2,1/(cell=column A),column B)
But it did not work.
Can you please give me an idea how to get the last date?

enter image description here