Excel: How to find the date of the last matching row?

So I have a master spreadsheet that has 20k+ rows containing monthly leasing data. It has information like a person's name, when they leased a car, what kind of car they have, etc. Most of the rows are the exact same except for the cell that states which month they leased it in (for ex., it will say 4/1/2016 or 5/1/2016).

I need to find the final row in the data that matches the other rows so that I can find out when they retued the car.

For example, if John Doe leased a honda pilot on 1/1/2016 and the last known report that shows that he still had it leased was 5/1/2016, I need to find the row that has "John Doe", "Honda Pilot", and "5/1/2016" on it. But, it won't show up on the report in the same sheet that lists the June leases or any of the following ones.

If someone could help me out with this, that'd be very appreciated since I'm really confused as to how to do this. Feel free to ask any questions in case my explanation wasn't clear enough. Thanks in advance!

Recent Questions...