Data Validation-Dependent Lists

  • Thread starter Thread starter TonyK
  • Start date Start date
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
 
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
Multi-level dependent data validation 3
stumped on creating dependent data validation lists 1
Data Validation List - Dependant based on numeric values 4
data Validation Dependent List Error 2
dependent lists on data validation 3
Indirect function help 2

Back
Top