| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation dependent lists | Excel Discussion (Misc queries) | |||
| dependent lists on data validation | Excel Discussion (Misc queries) | |||
| Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
| Data Validation & Dependent Lists | Excel Worksheet Functions | |||
| Data Validation - Create dependent lists | Excel Discussion (Misc queries) | |||
Linear Mode
