Excel, drop-down list changes contents of another cell, not formulaic

0
votes

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.

1
exceldrop-down-menu
I only mean that it is not a formula I am trying to get to work, i am just trying to coordinate the contents of two cells. I tried the VLOOKUP, and I don't think I am savvy enough to get it to work properly. – Noah Truax

1 Answers

0
votes

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.