Tying together items from a dropdown list to results in another cell

Hello, I have designed an Excel program for my college that we use to track what courses our students have taken and how many and what courses they still need to graduate. I have a incorporated a number of different features such as a GPA calculator, help system, etc. I would like to add searchable database, if this is even possible in Excel. Here is what I want to do.

A person clicks on cell "A" and a dropdown list appears of all the courses we offer. The person selects a course from the list and in cell "B" a description of the course appears along with other important information. So if a person is curious about BIO 112. They could select BIO 112 from cell A and in cell B it would pop up something like "BIO 112 - Biology 12 is an introductory biology course. It can be taken together with the BIO 113 Lab. It has no prerequisites."

Is something like this possible in Excel?

Thanks!

I do not have such a table, but I could certainly make one. I haven't used that command before, but I'll try it. Thanks!

Great, thanks!