Dependent list problem

Try this...............................there is no substitute for clean data

Thanks, but simple INDIRECT was under control. If you want to scale Excel out (us much as it is scalable at all), you want things in drop-downs to be readable for the people. I would like that first drop-drown displays full names and not range names.