Display multiple Values depending on selection

John_CGS

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. 

 

Paul Newcome

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.

John_CGS

Paul, you hero. Thank you, 

Paul Newcome

Happy to help, John!