'Excel, drop-down list changes contents of another cell, not formulaic
How do I make one cell display a value based on another cell choice that is a drop-down list selection? I don't know how to do macros, and I have tried researching. I think the question about displaying a custom state based on an sls file is close, but I don't know what and sls file is or how to code. Is there a simple way to tie two cell values together? eg. I want to be able to change the dollar value displayed in cell B (which represents a real cost of a subscription) based on what subscription choice I select from a drop-down list in cell A.
Solution 1:[1]
Say cell A1 has a Data Validation pull-down allowing you to select one of:
cat
dog
bird
snake
In another cell enter:
=LOOKUP(A1,{"cat","dog","bird","snake"},{10,20,30,40})
=LOOKUP(A1,{"bird","cat","dog","snake"},{10,20,30,40})
The list in the formula must be in alphabetic order.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |