I have a dataset containing speed-distance profiles of a group of vehicles.
The three categories of interest a vehicle number, speed, distance. I am
trying to create a list of the minimum and maximum speeds for each vehicle,
along with their corresponding distances. I can use a PivotTable to find the
min/max speeds for each vehicle, but I haven't found a good way to identify
the corresponding distances and put them in the table as well. Each vehicle
has multiple speed readings, so a basic VLOOKUP formula will only return the
last speed reading in the list for each vehicle. Is there a way to use
VLOOKUP in series (a nested VLOOKUP) to look for a vehicle number, then the
min/max speed in the profile of that vehicle, and then return the
corresponding distance?