On Feb 2, 7:51*pm, Bill Manville wrote:
Put your 30 course codes in a column
Put the 30 descriptions in the adjacent column to the right.
Say they occupy A1:B30 on sheet named Table.

In column E of your main sheet, for example in row 2, put formula
=VLOOKUP(D2,Table!$A$1:$B$30,2,FALSE)

Copy to the other cells in column E

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thanks so much. I couldn't get it to work at first. I had N/A in the
cells where I pasted the formula (in columm E). But then I clicked on
the words under the formula bar (the words that said table_array) and
then it started working. I'm not sure what that did, but the formula
wouldn't work until I did that. I only used pretend numbers and
courses to try out the formula and so when I get time I'm going to put
it in all the data for the real courses and make sure I can still get
it to work. Thanks again.