Returning the most recent value that matches multiple criteria (cross-sheet lookup)
I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.).
For my source sheet, I'm using a repair and maintenance sheet that covers all repairs and maintenance performed on all machines.
My desire is to only return the most recent odometer readings/machine hours of these services.
I tried VLOOKUP but can only search for one value and return 1 value.
How do I get (Can I get) SmartSheet to return a cross-sheet value that meets 2 or more criteria and can this work if there are multiple matches which differ only by when the entry was made?