Data Validation-Dependent Lists

T

TonyK

Hi
I have a spreadhseet which uses the INDIRECT function to display a list of
possible entries in a drop down box in Col B depending on the selection from
a dropdown box in Col A. I now need to expand the formula to look at
multiple lists (depending on the selection in column A) from lists which span
cols B through AZ. The function I have at the moment is "INDIRECT(A2)". Any
help would be appreciated.
TonyK
 
P

Paul

This approach works fine for small lists, but what you do if you have many
lists or many options?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - dependant Lists 1
Data Validation - Dependant Lists 3
stumped on creating dependent data validation lists 1
Multi-level dependent data validation 3
How to create 2 dependent drop down lists from 1 original drop dow 5
Data Validation - Multiple Dependent Lists 4
Data validation dependent lists 4
dependent lists on data validation 3

Top