Dropdown Based upon a List

[bluelabel]

I have a master list of data which has sub sections.

I want to be able to base a list on a subsection based upon a dropdown in another cell.

Club 1	Comp 1
Club 2	Comp 1
Club 1	Comp 2
Club 3	Comp 2

I want to be able to have a drop down which lists all the Comps and when I select "Comp 1" in cell A1, i want cell B1 to only show a list that contains those clubs with Comp 1 against them and then I can select a club from that list.

Is this possible please, and if so, how?

Thanks.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)