Ravi Sir's Cards › Excel
Car and Bike Service Log in Excel (card 1 of 2)
Revision card 1 for Car and Bike Service Log in Excel: Date of the last general service: =LOOKUP(2,1/(C9:C14="General service"),A9:A14) gives 14-03-2026; Odometer at the last general service: =LOOKUP(2,1/(C9:C14="General service"),B9:B14) gives 40,210; Next service at (km): =H10+B5 gives 50,210. Includes an example data table.
Read card text
What this card says
1 for Car and Bike Service Log in Excel: Date of the last general service: =LOOKUP(2,1/(C9:C14="General service"),A9:A14) gives 14-03-2026
Odometer at the last general service: =LOOKUP(2,1/(C9:C14="General service"),B9:B14) gives 40,210
Next service at (km): =H10+B5 gives 50,210. Includes an
Example
data table
Learn this in the lesson: Car and Bike Service Log in Excel: Next Service Due by km or Date, and Maintenance Cost