Share via

Choose from a List based on a previous list selection

Anonymous
2022-12-19T18:08:36+00:00

To be more user friendly, is there a way to use the answer from a dropdown list to be the trigger for a new drop down list on the next cell in that line?

For example, I want the user to choose the region name that we use for business divisions. Once they do that, I'd like them to choose from a list of the offices in that region.

First drop down (Region):

Central

East

North

West

If they choose "Central", the next drop down box only shows them the offices within the Central Region

Second drop down (Office)

St Louis

Davenport

Chicago

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2022-12-20T15:22:02+00:00

    You need to create a named range with your values. For example, select the cells with

    St Louis

    Davenport

    Chicago

    and in the name box above cell A1, type Central and press Enter. Then when you select Central in the first drop down, the other dropdown will change.

    Here is a working file....

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-20T16:59:14+00:00

    Thank You!!!

    0 comments
  2. Anonymous
    2022-12-20T14:33:39+00:00

    Thank you for your assistance, I have a list of Regions with their corresponding offices underneath the region. I have a "choose from list" that allows the user to choose their region as my first dropdown. The cell next to that cell would be the "choose from a list" the offices within that region. I tried putting the "=indirect(first dropdown cell)" in the list but it returned an error. How does it know to go and reference the table of the regions and their offices?

    Regards,

    Matt

    0 comments
  3. Anonymous
    2022-12-19T18:39:09+00:00

    You need to create 4 named lists, with the appropriate office names for each:

    Central

    East

    North

    West

    and then in the second dropdown, use

    =INDIRECT(cell address of first dropdown)

    0 comments