Forum Discussion
Dependent Drop Downs across multiple rows in a spreadsheet
Hello. I've been trying to create a spreadsheet that has a dependent dropdown column. However, all the guides and advice I've seen so far have been functional only when you only need a single cell or...
It won't allow me to enter =INDIRECT(A2) I get the error message "This entry leads to an error. Try enterting different values to continue."
That means that A2 currently doesn't evaluate to a valid range address or named range...
