Needing help with an equation for MPG on a sheet with multiple vehicles.

I have a spreadsheet that is a log of fleet vehicles, how much gas they purchased, when they did this and the odometer reading at the time of purchase. Multiple vehicles are on this log.

I am looking for an equation that will search the range for a specific vehicle number then from the results subtract the smallest from the largest odometer reading to give me the total miles traveled for that vehicle in the current log.

I appreciate any help with this. I am just tired of banging my head on the wall over it.

Thanks,
~tink