Here is how we combine that information for our audit reports. Our office guys got lightning fast at doing VLOOKUP functions in excell. This is a copy and paste from our Tennessee Standard LLC Audit Process:
In order to perform a successful truck audit, we must first create a report of the current truck inventory, as seen by the system, combined with the min/max report from the appropriate truck template. We must use the VLOOKUP function to create this sheet.