Multiple Column Dynamic Dependent List

I hope someone can help me or point me in the right.

I am attempting to create a form in excel with dynamic data validation fields. What has me stumped is that I want to create multiple complex dependencies (for instance, if you select something from a drop-down list in the first field, that then gives you a specific range in the second field. Then based on what you placed in the second field it gives you a specific range in the third field.). What I can't seem to work out is the formula for making this work.

Is this impossible?

Also sometimes the third field my be blank.

Here is an example of what I am trying to accomplish


Assets 2.PNG