Dependant Data Validation

Hi there,

just wondering if I could have a little help with (what I believe is called) dependent data validation.

I have a data validation list in E18 with 22 possible outcomes, I have another data validation list in E22 with a potential 29 outcomes.

The potential 29 outcomes in E22 are relevant to the answer in E18, basically some need to show and some don't.

I have used name manager (in another sheet) to name the items in E18 and all the variants for each answer for E22 from E18. - If that makes sense. :-D

I believe I need to use an INDIRECT function in the data validation menu but I'm not sure, any help would be greatly received.

Thank you!