Connect cells to dropdown menu

Occasional Visitor


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)


2 Replies

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.




Are you saying that you want to be able to type a value into a validation drop down list that doesn't exist in that list? And you want that value to then be added to the original drop down list?

You can easily change settings to allow any value to be typed into the list, but adding it to the original list requires VBA.