NEsted IFs in a data validation

[uk747]

Is there a limit to how many nested ifs you can have in a data validation.I tried pasting a formula but it wouldnt take the number of ifs or is there a better option if you have up to 10 lists and the result of the cell determines which list it will show

 

[Andrew Poulsom]

You can use named ranges and the INDIRECT function:

Excel Data Validation -- Dependent Lists

 

[uk747]

You can use named ranges and the INDIRECT function:

Excel Data Validation -- Dependent Lists

Thanks, did look at the link and works ok if the source is a word but if I had a 3, 4 or 5 word name in cell A1 the =indirect(A1) has problems for named range

 

[konew1]

The link posted by Andrew gives the method to resolve this.

 

[uk747]

couldnt find anything that would work.If A1 contained different 4 letter words and different 3 and 5 letter words I couldnt get a different list to appear