Help with IF formula for HS Course Codes

[Sharon]

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

(I did post this in Excel Links Forum by mistake, so I apoligize for
posting twice.)

 

[Earl Kiosterud]

Sharon,

The VLOOKUP function is exactly what what you need. You put it in the column E cells. The
table in which it looks up the name (from the course code) must have the course code column
to the left of the description. Give specifics as to your sheet names, columns, etc., and
we can make an exact formula for you.

 

[Ron Rosenfeld]

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

(I did post this in Excel Links Forum by mistake, so I apoligize for
posting twice.)

What you probably want is the VLOOKUP worksheet function. Look at HELP for
this function.
--ron

 

[drew.dipietro]

You want: VLOOKUP(<cell you want to use as reference>,<array you want
to look at>,<column in the array that you want a return value from>)

So suppose you have a table that has all your highschool classes lined
up horizontally with your college classes - you also have a table with
all the highschool classes and you want to return the appropriate
college class in a column next to it. Take the cell you want to return
the value in - type "=vlookup(" type or click on the cell you want to
return a value for ",", then type or select the table you you're going
to use as a guide for returning your value for ",", and then the
column in the table that you want to use as the return column ")". If
all else fails - "F1" for help .