Referring one cell to another where one cells value can create a predefined value in another cell.

Question

So I have prepared a&nbsp; (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.&nbsp;&nbsp;So hypothetically...&nbsp;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?&nbsp;&nbsp;Any ideas?&nbsp;&nbsp;&nbsp;

man fai chan · Answer

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)

Forum Discussion

Referring one cell to another where one cells value can create a predefined value in another cell.

Share

Resources