For all of you IF Statement experts.......

[mcr1]

I have a dropdown menu in cell A1 with 3 names in it. Jones, Davis, an
Smith. In Cell A2 I want the cell to automatically show the codename
have given for the respective person in cell A1. Is this possible?

I use thie code for just one person, but I dont know how to properl
add to it to make it usable for 3 people.

=IF(A1="Jones","BIGFISH","")

Example....

In cell A1, I select Jones. I want his codename, Bigfish, t
automatically appear in cell A2. Thanks in advance.

Miles Ree

 

[vhspring2000]

=IF(A1="Jones","BIGFISH",IF(A1="Davis","SUPERBIGFISH",IF(A1="Smith","LITTLEFISH","")))

 

[Ken Wright]

=IF(A1="Jones","BIGFISH",IF(A1="Smith","SMALLFISH",IF(A1="Paddy","NOFISH","")))

 

[Ron Rosenfeld]

I have a dropdown menu in cell A1 with 3 names in it. Jones, Davis, and
Smith. In Cell A2 I want the cell to automatically show the codename I
have given for the respective person in cell A1. Is this possible?

I use thie code for just one person, but I dont know how to properly
add to it to make it usable for 3 people.

=IF(A1="Jones","BIGFISH","")

Example....

In cell A1, I select Jones. I want his codename, Bigfish, to
automatically appear in cell A2. Thanks in advance.

Miles Reed

Here's a formula that is extendable for as many fish or names as you want.

=VLOOKUP(A1,{"Jones","BIGFISH";"Smith","LITTLEFISH";"Davis","SHARK"},2,0)

The names and fish could also be in a two column table, with the table
reference substituted for the array constant in the formula.




--ron

 

[tjtjjtjt]

Well, you could do something like this
IF(A1="Jones","Bigfish",If(A1="Smith","Cobra",IF(A1="Panza","Sancho","Invalid Name")))

BUT, you are probably better off looking at VLOOKUP as an alternative.
http://www.contextures.com/xlFunctions02.html

tj