Forum Discussion

null null's avatar
null null
Copper Contributor
May 30, 2018

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 next to it. 

 

So hypothetically...

 

Say cell D2 has a drop down list, and I choose the second option reading "Configuration B", and cell D2 now reads Configuration B. What i'm trying to achieve is once I've chosen "Configuration B" then the cell in D3 (next to it) automatically then lists the appropriate value (in dollars) of what Configuration B costs? 

 

Any ideas? 

 

 

  • Man Fai Chan's avatar
    Man Fai Chan
    Iron Contributor

    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)

     

Resources