Hi all, I'm trying to do something but can't figure out a simple way to do it. I'm sure you will have some ideas!
I have a list of vehicles, and each day they get inspected and the odometer readings (currents kilometers or KM Start) are recorded in column E. In column F, I would like to automatically display the kilometers remaining until the vehicle is due for a service, after I pick the vehicle from the drop down list on Column C and enter the KM Start readings in Column E.
This would have to take information in the Unit No. cell (Column C) and the Service Due cells (E3 to E10) for that vehicle, then calculate the remaining kilometers (by taking the KM Start from the Service Due numbers).
Have a look at the image below, and I have attached the spreadsheet for you to play with. You will see in cell F13 my attempt, which doesn't work for the list of vehicles just the one I have specified in the formula.
Let me know if I need to explain my question more clearly.
Thank you!
1.JPG
Bookmarks