Display multiple Values depending on selection
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.
Comments

THe basics of an IF statement are
=IF(This is true, then do this, if not then do this)
To nest IF statements, think of it this way...
=IF(A1 is "Bob", then display 1, if it is NOT "Bob" then IF(A1 is "Bill", then display 2, if it is not "Bill" then IF(A1 is "Ben", then display 3, if it is not "Ben" then display "No Name")))
=IF(A1 = "Bob", 1, IF(A1 = "Bill", 2, IF(A1 = "Ben", 3, "No Name")))
NOTE: I used 3 IF statements, so I closed the formula out with 3 ). You do have to remember to close out ALL statements when nesting.
This will display a 1 for Bob, a 2 for Bill, a 3 for Ben, and if it is neither of the three, it will say No Name.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Paul, you hero. Thank you,

Happy to help, John!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!