i try to pull last paymant day in this example. I try vlook and this

Use the query formula to get the last payment date:

=query(A2:B, "select A where B = 'Payment' order by A desc limit 1")

Output: