Forum Discussion

emil pettersson's avatar
emil pettersson
Copper Contributor
Mar 08, 2018

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 ...
Formulas & Functions
Need Help
Tinn Keeper's avatar
Tinn Keeper
Brass Contributor
Mar 08, 2018

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

Resources