Drop Down List Based on Previous Column's Drop Down List Selection - Categories/Sub-Categories

[DonnaE]

Any help is appreciated on the following.  Thanks!

I'm setting up a sheet with columns to categorize/sub-categorize data.

I'd like a Category Column which has a Drop-Down List and a Sub-Category Column with a Drop-Down List based on the selected "Category" from the previous Drop-Down List.

Basically, if my lists look as follows below (Category List/Sub-Category List), how do I display the Sub-Category Drop-Down List for the corresponding Category (only) without having to include *all* Sub-Categories to choose from?

• If "Category Column" Drop-Down Selection = Policy, then
  • "Sub-Category Column" Drop-Down Selection = only the option of....
    • "Personnel, Product, Refund/Cancellation, Safety, Security, Payroll, Attendance"

Categories Drop-Down List:

• Promotions Category
  • Sub-Categories for Promotions Category:
    • Corporate
    • Membership Based
    • Customer Type
    • Sale
• Policy Category
  • Sub-Categories for Policy Category:
    • Personnel
    • Product
    • Refund/Cancellation
    • Safety
    • Security
    • Payroll
    • Attendance
• System Category
  • Sub-Cateogories for System Category:
    • Update
    • Enhancement
    • Replacement
    • Alert
• Process Category
  • Sub-Categories for Process Category:
    • Call Handling
    • Product Sales
    • Requests
    • Complaints
    • Issuing Compensation

[#2 · Accepted solution]

Hello Donna,
The dynamic dependent drop-down list solution for you is similar to my reply here:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352333#M25764

[#3]

Hello Donna, 

Except that there are only 2 drop-down lists herein, the attached file is exactly the same as that which I uploaded in this link, which has 3: 

https://techcommunity.microsoft.com/t5/Excel/Dependent-Drop-down-List-Formula-for-only-showing-cells...

Cheers,

Twifoo

[#4]

Thanks so much for the helpful direction, Twifoo!

[#5]

Welcome, Donna.

[#6]

@Twifoo 

Dear Twifoo

I want to make same drop down lists with some Financial Data having Heads in Any Column and Sub Accounts in Next Column. I have seen your Maths Tracker workbook but it is not showing complete formula/range in source while applying data validation. Can you plz explain how can I relate Heads from one column to Sub Accounts in different columns.

[#7]

To see the details of the named formulas, paste the list of defined names by following the instructions in this link:
https://excelribbon.tips.net/T007731_Printing_a_List_of_Named_Ranges