Multi-level dependent lists

Hi,

I need to set up an excel sheet with dependent data validation that is multiple levels deep.

ie. Select value from dropdown list in Col A returns dependant list in Col B, select value from the list in Col B returns list in Col C etc.

Is this possible?

Also, is it possible to set multiple values to return the same list? ie in the drop down you have 4 items. Each returns a dependent list but items 1 and 3 both return the same dependent list. Just saves me making many copies of the same list with different names which isn't a huge issue.

Really appreciate any help you can provide.

Hi and welcome to the board

This link will get you on track

So glad the reply wasn't "Not possible"! I'll check out that link now. Thanks.

Ah, yeah I used that exact page initially to get going but when I try return a list it gives me a #value! error.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I was thinking about the cross post thing but then it said something about usenet so I left it. My bad. And it was just me being daft and putting the =indirect(a2) in the cell not via the data validation window.