Hi Folks,
I've got two sheets - first one showing overspeed details, the second showing load details.
I need to find an accurate way of looking up a driver's name in the load summary sheet and returning it to the related overspeed in the overspeed sheet.
NOTE: The vehicle number showing in the overspeed sheet could be contained in either "Truck", "Trailer A", or "Trailer B" in the load summary sheet.
I've attached samples of the two sheets.
Can someone please help me out?
Thanks very much.
I've got two sheets - first one showing overspeed details, the second showing load details.
I need to find an accurate way of looking up a driver's name in the load summary sheet and returning it to the related overspeed in the overspeed sheet.
NOTE: The vehicle number showing in the overspeed sheet could be contained in either "Truck", "Trailer A", or "Trailer B" in the load summary sheet.
I've attached samples of the two sheets.
Can someone please help me out?
Thanks very much.