How to change the value of a cell depending on another cell

Options

I have a task, on a dropping list I have 3 row, each row according a value in another cell which should be change, example:

Dropping list on a b9 cell contains value a1,a2,a3

In a cell e9 I want to input automatically 10, 20 or 30, if

a1=10, b2=20, a3=30

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!