Data Validation-Dependent Lists
 

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

Data Validation-Dependent Lists
 

See:

http://www.contextures.com/xlDataVal02.html
--
Gary''s Student - gsnu200832


"TonyK" wrote:

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

Data Validation-Dependent Lists
 

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

"TonyK" wrote:

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