Forum Discussion
Referring one cell to another where one cells value can create a predefined value in another cell.
So I have prepared a (for example) drop down menu for specific cells. What I'm trying to do make the chosen value (from the drop down list) to automatically assign a predefined value into the cell n...
I think you may consider a table contains the type of configurations and the corresponding values. And then use vlookup to show the value.
For example:
Column AA: list of the types of configurations
Column AB: the corresponding value for each configuration.
Then, in the cell of value: vlookup(D2,AA:AB,2,false)
