It turns out this is suprisingly hard to Google.
What I have is a large sheet with basically in column A a name, in column B a category and then in many other columns more information.
What I would like is to be able is to select a category type from a data validation list dropdown and then the second data validation list should only contain names from column A that have that category in column B. Creating the first dropdown is easy and can be done by hand but it seems there is no way to do the second part.
Googling only gives results for dependent lists which is not what I want.
A super simple, made up, example of what I'm talking about:
So from the first dropdown I would select The Beatles and then only get to see (and select) George, John, Paul, and Ringo from the second dropdown.
Is this possible at all or does Excel have no way of supporting this?