Change Cell Values based on drop down selection

[Jmwend]

I would like for my worksheet to automatically fill values in specified cells based on a drop down list selection.

For instance, If the user selects "1" in the drop down list in cell A1, I would like 2 to automatically appear in cell B1, and 3 to automatically appear in cell B2. Then, if the user changes his drop down selection from 1 to "2", I would like the number 3 to automatically appear in cell B1, and 4 to appear in cell B2.

Please let me know how this is possible. Thanks in advance for the help.

 

[jmthompson]

The easiest way, if you examples hold for all possibilities:
"B1" formula =A1+1
"B2" formula =B1+1

 

[Jmwend]

I actually just used those values and cells to illustrate what I wanted to do, those aren't actually the cells or values that I will be using. My drop down list is in cell B15 and contains "high, medium and low" I want to populate cells F20:F26 with specific values depending on the selection of "high medium or low" in the drop down list.

 

[jmthompson]

Are the values for High, Medium and low consistent?
Will B2 always be 1 more than B1, or is there a second set of contingent values?

 

[Jmwend]

No the values for cells F20:F26 will be like .5ppm , .5ppm, .4ppm, etc. So they are random (not a mathematical sequence) and have characters behind them.

 

[jmthompson]

Will "High" always populate the same values in F20:F26?

same question for medium and low

 

[mikerickson]

You could use an IF statemtent

=IF(A1="High","oneValue",IF(A1="Medium","twoValue","threeValue"))

or Choose

=CHOOSE(MATCH(A1,{"High","Medium","Low"},0), "oneValue", "twoValue", "threeValue")

or Lookup

=LOOKUP(A1,{"High", "Low", "Medium"},{"oneValue", "threeValue", "twoValue"})

 

[Jmwend]

Great, thank you!