How can I do this (below) in 2007 Excel?

I have a list of high school course codes for some college classes in
Column D. In column E I would like the NAME of the class, but I do NOT
want to look up all 500 course codes to manually type in the correct
name of the class. (Column A, B, C are used for first, middle, last
name)

So, I'm thinking that there must be a way to put in an IF formula of
some type that say IF the course code is 1001 in columnm D, then in
column E the name will be English 1 (for example). And IF the course
code is 1002, it will read English 2 in column E, etc.

I have about 30 course codes that I need to plug in. All I can think
if of is the IF formula itself must list all 30 course codes. Or
perhaps there is an IF formula tells Excel to check against a list of
course codes in cells XXX that is on a separate worksheet. And
perhaps it is not an IF formula at all, but some other formula.

How do I go about doing this? I am only familiar with basic =SUM
formulas, so detailed directions would be helpful.

Thanks,
Sharon