Hey Forum!
I want to create a long drop down list, which refers to another drop down list by using the "=INDIRECT" formula.
This is working perfectly as long as i do the data validation in every single cell and add =INDIRECT(F...).
Is there any possibility to use data validation only once, but still refering to the cell on the left all the time?
I tried several combinations with the $ sign, but whenever i try, the drop down list only refers to the first cell of the independent drop down list...