Need some kind of

Hello,

I have a spreadsheet with information concerning class ID numbers and attendees but it also contains multiple rows for dates.

I want to present the information in a more meaningful way, so that the ID numbers are replaced with the class name.

For example I have a table like this:

Class ID     Class Name
1              English
2              Math
3              Science
4              History

Then my actual data looks like this:

Date    Class ID     Attendees
10/14     1                 5
10/15     1                 3
10/16     3                 4
10/17     2                 3
10/18     2                 5
10/19     4                 3


I want to replace the Class ID numbers with the matching text names. I could use a search and replace but in reality the class list is about 30 items long and it seems there must be a formula that could accomplish this.

Is this possible?

thanks a bunch,

Maureen