Clever lists in Excel

Create dependent drop down lists in Excel
“Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, and only Fruit items appear in the drop down list in column B.”​

Another Excel solution in search of a problem. I must be able to try this out on something…

Author: Terry Madeley

Works with student data and enjoys reading about art, data, education and technology.

%d bloggers like this: