Excel Formula - Latest Date is Service 1 then next is Service 2

%3CLINGO-SUB%20id%3D%22lingo-sub-2753079%22%20slang%3D%22en-US%22%3EExcel%20Formula%20-%20Latest%20Date%20is%20Service%201%20then%20next%20is%20Service%202%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2753079%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20have%20a%20complex%20(to%20me!)%20excel%20formula%20needed%20that%20I%20cannot%20get%20my%20head%20around.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20two%20tabs.%20One%20as%20a%20'Dashboard'%20and%20the%20second%20tab%20as%20the%20data%20to%20run%20this.%20The%20dashboard%20shows%204%20columns%20and%20multiple%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEssentially%20I%20am%20tracking%20each%20registration%20(vehicle)%20that%20has%20a%20service%20every%2014%20days.%20The%20service%20alternates%20between%20service%201%20and%20service%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20-%20Registration%3C%2FP%3E%3CP%3EColumn%20B%20-%20Last%20Service%3C%2FP%3E%3CP%3EColumn%20C%20-%20Next%20Service%3C%2FP%3E%3CP%3EColumn%20D%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A-C%20is%20fine%20and%20working%20however%20I%20cannot%20come%20up%20with%20a%20formula%20to%20put%20in%20column%20D%20that%20shows%20what%20the%20next%20service%20will%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20sheet%20is%20used%20to%20record%20registration%2C%20service%20date%20and%20type%20of%20service.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20really%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2753079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
Not applicable

Hi - I have a complex (to me!) excel formula needed that I cannot get my head around.

 

I have a spreadsheet with two tabs. One as a 'Dashboard' and the second tab as the data to run this. The dashboard shows 4 columns and multiple rows.

 

Essentially I am tracking each registration (vehicle) that has a service every 14 days. The service alternates between service 1 and service 2.

 

Column A - Registration

Column B - Last Service

Column C - Next Service

Column D -

 

Column A-C is fine and working however I cannot come up with a formula to put in column D that shows what the next service will be.

 

The data sheet is used to record registration, service date and type of service.

 

Any help really appreciated.

 

Thanks,

 

2 Replies
If you can bring back the last type of service could you do a formula that looks up that data and if equal to 1 return 2 else return 1?
The data is still there in my data tab but unsure the formula to make sure it looked up the latest service as the data holds all services for the entire history.

It would need to be IF registration is the same as registration on the dashboard and the IS the latest date THEN the next service is the other