thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
Hello all -
I currently use the following setup:
Cell A1 can have any one of the following values: arealight, wallpack,highbay,wrap
Cell B1 contains a validation list which equals =indirect(A1)
This function serves to look up the values i want to select from, so if i want to look at all "Arealight' options then i select arealight and the validation list will give me a list of all them.
Now what if these lists are in another workbook. Is there a way to use this indirect function in the same manner? I can't point the formula to a specific range b/c it is dynamic (i.e the list i need can change from arealight, wallpack, highbay, wrap).
Any help is greatly appreciated!
I currently use the following setup:
Cell A1 can have any one of the following values: arealight, wallpack,highbay,wrap
Cell B1 contains a validation list which equals =indirect(A1)
This function serves to look up the values i want to select from, so if i want to look at all "Arealight' options then i select arealight and the validation list will give me a list of all them.
Now what if these lists are in another workbook. Is there a way to use this indirect function in the same manner? I can't point the formula to a specific range b/c it is dynamic (i.e the list i need can change from arealight, wallpack, highbay, wrap).
Any help is greatly appreciated!