What is the proper way to reference data based on mixed dates?

I already have this operating, but I'm fairly new to excel and it feels like there's probably a better way to go about it than how I'm doing it currently. So what is the correct way to reference information based on a date when the dates I'm referencing aren't necessarily the same? Probably a simple question for all of you, and thank you in advance for your help.

Image 1

Image 2

Based on the data in image 1, the expected outcomes in image 2 would be:

A = 3200

B = 10100

C = 14000

D = 500

EDIT: Didn't specify (my fault), but because the input for odometers is done by humans, I can't 100% trust that the highest value is going to be the correct value. Additionally, while the example doesn't show this (again, my fault) any given vehicle may have more than one entry per date.