Multiple Dependent drop down lists

Hi Experts, I'm new here and have spent hours looking through the existing threads for some guidance, so I apologize in advance if this is already out there.

I'm trying to build a multiple dependent drop down list, but the third dropdown is dependent on the first two.
For this example, there are two types for the first dropdown (car/truck), then the second dropdown is the subcategories of each. The third dropdown is the rate, but this is what screws me up, there's a week rate and a month.
So say the first dropdown you select 'Car', then the second, you select 'aa', how do I go about making the third dropdown 'Week/Month, with corresponding rates only of that specific model appearing in the fourth cell?
Is this possible, or perhaps an easier way to achieve this end?
Workbook attached.
I really hope I've explained this properly.

Thanks in advance!

Welcome to the forum.

For data validation in J4, use:
=$C$1:$D$1

And in K4, this formula:

Formula:

Please Login or Register  to view this content.

Good luck!

That's incredible. Exactly what I was trying do to. Thanks so much for your help!

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!