How Do I Make an Excel DropDown List Populate Cells with other DropDowns?

Hello,

I have a worksheet with 4 defined lists. 1 list is active on the sheet as a key. I want to make it so that the selection from the first list will allow the worksheet to automatically apply one of the other defined lists to a range of cell base on the choice made.

The scenario is as follows:

The dropdown list provided contains 3 venues.

Each Venue has different people attending that particular venue.

I have cells which need to be populated with the names of certain individuals from the list of people attending.

The Sheet is currently laid out as follows:

Cell B5 = Drop down list with 3 venue names. Venue A, Venue B, Venue C for example.

Cell A8 = Date
Cell B8 = Full Name
Cell C8 = Start Time
Cell D8 = End Time

If I select Venue A from the drop down, I want Cell B8 (Full Name) to provide me with a list of choices from a defined selection of cells called VenueA_Staff. And obviously if Cell B8 is Venue B then B8 should show me a drop down with choices from a predefined list called VenueB_Staff etc etc.

I hope that makes sense.

I'd be obliged if any of you could lend a hand on this... it's driving me mad. I had assume originally that it was a simple IF statement... Then I though an INDIRECT statement but have failed on both fronts.

Thanks for your time!

Regards,
Bill

Fantastic....

Thanks for the help guys.... I was almost there with the INDIRECT... The problem was i was calling the sublist by a slightly different name from the Primary list that referenced it.

Thanks again to you both... it was just what i needed!

Regards,
Bill