Need excel help with lists

[cchen]

So I have one master list and then subcategories that correspond to that list.

For example:

Master--> Sub

Contract Related-->Master Agreement
Contract Related-->SLAs
IT Projects -->Change Management
IT Projects -->Estimation
ODC Operations-->ODC Accounting Processes
ODC Operations-->Onboarding Process

I know that in excel, I can use the data validation so that any subsequent lists I choose are limited to the list that I specify.

The problem is, how can I set it up so that the sub-categories correspond to what was chosen in the master category?

i.e. If choose IT Projects in one column, I want to be able to only choose either Change Management or Estimation for the sub category.

Is this doable without writing VB code?