Mar 08 2018
01:37 AM
- last edited on
Jul 25 2018
11:18 AM
by
TechCommunityAP
Mar 08 2018
01:37 AM
- last edited on
Jul 25 2018
11:18 AM
by
TechCommunityAP
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 in the drop down and the information that's connected to it will change based on what I choose from the menu. Is there any way i can do this?
Thanks in advance.
Best regards.
(The pictures is how I want it work)
Mar 08 2018 07:18 AM
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
Mar 09 2018 10:00 PM