Dynamic Drop Down List (1 Viewer)

[grifter]

So if I had a list of Projects and associated subjects how can I make drop down list for each so I would see a list of projects in one drop down, then whatever I selected for project, it would show only those subjects in the next drop down associated with that project. Here's a small example:

Main list:

Project1 - Subject 1-1
Project1 - Subject 1-2
Project1 - Subject 1-3
Project2 - Subject 2-1
Project2 - Subject 2-2
Project2 - Subject 2-3

Drop down 1 should be:

Project1
Project2

I pick Project1

Drop down 2 shows this:

Subject 1-1
Subject 1-2
Subject 1-3

I tried setting up an Excel table from my main list of projects/Subjects but I've no idea what to do with it from there, tried various tutorials, none of which were actually dealing with multiple items in a list, just simple drop down lists with no duplicates.

Thanks

G

 

[Minty]

You are describing what in Access would be "Cascading Combos", however, I have no idea how to do that in Excel.
Luckily this site does https://www.extendoffice.com/documents/excel/5301-excel-cascading-drop-down.html

 

[arnelgp]

you did not look hard.
see this link using Data Validation.
How to make a dependent (cascading) drop-down list in Excel (ablebits.com)

 

[grifter]

you did not look hard.
see this link using Data Validation.
How to make a dependent (cascading) drop-down list in Excel (ablebits.com)

I'd no idea that's what it was called - a cascading drop down list, but now that I know, I can read through these solutions.