Forum Discussion
Solved
OFFICE 365 - Subtraction between last entered value meeting criteria and another cell
Greetings to the forum! Please find attached file for your reference. In cell E3 in the "Summary" tab I would like to find the LATEST entry in column D ("Raw Data" tab) from the value in cell B...
Try this one:
=LET( lookup, FleetNo & "Service" & "Engine", lookup_arr, Raw_Fleet & TransType & Component, last_raw, XLOOKUP(lookup, lookup_arr, KMHRS, 0, , -1), IFERROR(LatestMileage - last_raw, LatestMileage) )
Thank you Gentlemen and sorry for the late reply!
Both your solutions worked, I'm extremely thankful
Vito
Both your solutions worked, I'm extremely thankful
Vito
