Forum Discussion
Expand amount of characters for source in data validation
AaronvdHeijden Use Named Ranges and INDIRECT. I have attached a quick-and-dirty example demonstrating this. You would have to restructure your listings a bit, but it will work beautifully.
Note that Named ranges only accept normal characters, numbers and underscores and they NOT start with a number. Every sub-option will have to have it's own Named Range.
Thank you for you reply.
Example:
Column Type needs to look at value in colomn Groeptype and based on this value fill the dropdownlist.
I put down the source as below:
Here is the file.
AaronvdHeijden Use Named Ranges and INDIRECT. I have attached a quick-and-dirty example demonstrating this. You would have to restructure your listings a bit, but it will work beautifully.
Note that Named ranges only accept normal characters, numbers and underscores and they NOT start with a number. Every sub-option will have to have it's own Named Range.
- I will try this and it seems that it will work. Thank you very much