Forum Discussion
emil pettersson
Mar 08, 2018Copper Contributor
Connect cells to dropdown menu
Hello.
I'm trying to connect certain cells to a dropdown menu and I still want to be able to write in the cells that's connected to the drop down. In other words, I want to be able to change value ...
Tinn Keeper
Mar 08, 2018Brass Contributor
Hi Emil,
If my understanding is correct, you could use the formula =INDIRECT("Table2[2]") in your data validation field list.
Attached an example file.
Kr
TK