Display multiple Values depending on selection

Options
John_CGS
John_CGS ✭✭
edited 12/09/19 in Formulas and Functions

Hi guys (1st post!) 

I'm trying to display different numerical values in a cell depending on what selection is in another cell's text dropdown. 

Example

Dropdown choices.. Bob, Bill, Ben.. Cell A1

In Cell A2 I want to show '1', '2' or '3', depending on the A1 selection. 

I've been trying to use IF statements, but can only get it working for one selection (by hiding the value elsewhere in a hidden cell), but I cant figure out multiples. Would anyone have any suggestions? Is it even possible?

thank you. 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!