And
Also is it possible if they enter a vehicle number and a date that a different formula finds the miles for the most recent date to the date entered
Enter the date in D2 and again array formula:
=INDEX(B2:B20,MATCH(MAX(IF((A2:A20=E2)*(C2:C20<=D2),C2:C20)),IF((A2:A20=E2)*(C2:C20<=D2),C2:C20),0))
would do.
PS. nobody wants you to publish company data. Exactly* such sample file as you attached was what I ment.
*) Well, this case text explanation was (probably) good enough, but often it is wise to show also "manualy calculated" result(s). So in such case filled with data E2, D2, and manualy assessed F2 (miles for last), G2 (miles for last before D2).
Bookmarks