If statement - 3 conditions

[Iappreciate]

I don't think it is too complex but I have been struggling with this. I have 3 columns:


A1 = ID
A2 = ID Name
A3 is where the If statement will go

I need A3 to display as - If A1 equals “1” then A3 should say “Harvard”. If A1 equals “2” then A3 should say “MIT”. If A1 equals “3” then A3 should say whatever is in A2.

Thank you.

[AliGW]

Try this:

=CHOOSE(A1,"Harvard","MIT",A2)

Are you still using Excel 2007???

[Iappreciate]

I botched my question. It is not A1, A2, A1. It is A1, B1, C1.

The A1 field has the ID#'s (1001, 1002, 1003, etc) as the records
B1 has the names associated with those ID's (Harvard, MIT, etc.)
C1 is where the outcome of the IF statment will be

The first two ID's can have different descriptions (e.g. 1001 can say "Harvard" or "Harvard University").

I need a statement in C1 that says:
If A1 = 1001 then "Harvard". If A1 = 1002 then "MIT", If A1 is anything other than 1001 or 1002 then pull in whatever is in B1.

Thank you.

[JohnTopley]

=IF(A1=1001,"Havard",IF(A1=1002,"MIT",B1))

[Iappreciate]

=IF(A1=1001,"Havard",IF(A1=1002,"MIT",B1))

Thank you!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.