Can Dependent Lists Be Auto-Updated From Out-of-Order Changes?

[Kogen]

I'm working on a stats tracker that will pull from the "Service Code" column, but I've seen an area of concern... The logical flow is from left to right, but if column A or B is changed, nothing to the right auto updates or blanks out. Is there a way to correct this so that everything stays under its correct pathways? Thanks for taking the time to review this.Task Tracker.xlsx

[FlameRetired]

Unless I am completely misunderstanding I don't get any of that. D2 returns Service Descriptions with every item in Service Code. I see no references to Client Type in the formula.

What am I missing?

Can you give us specific (and detailed) examples of what isn't working?

[Kogen]

Ok, so when the user of the task tracker starts a new line they fill the cells in from left to right. The lists are dependent on the previous cells (except D2), but if the user goes back to change say the "Customer Group," everything to the right stays the same. Though it's pretty straight forward that they should continue on an update the remaining cells to the right, my mind tells me that the cells should clear out and go blank so that user error is limited. Does that help with understanding any better? Thanks for your time.

[FlameRetired]

No I don't think that it does.

Customer Group issues are all addressed in the nested IFERRORs in Service Description. Changing Customer Group in B2 affects nothing in the D2 nor should it by the formula you have there. Also changing previous cells suggests dependent drop downs. Changing those previous cells does not change what is displayed in dependent drop downs. It only changes what is available in those dependent drop downs.

I will need another upload with 4 or 5 examples of different selections in the "previous cells" and what you expect D2 to return ... manually typed in. Hopefully this will give me a cleared idea of your meaning.