Creating Dynamic Schedule

I am trying to make a spreadsheet to assist me in scheduling the rest of my college classes. I have a column of all of the classes I still need to take. The two adjacent columns contain the units of the class, and an abbreviation of the term, respectively. In another section of the spreadsheet I have the terms broken down individually with an area for the class and the corresponding number of units.

If you open the spreadsheet, you will notice column D, labeled Term. I want to set the spreadsheet up in such a way that when I type in, for instance, F10 in the term corresponding to the class I am taking in Fall 2010, excel puts the corresponding course and number of units in the Fall 2010 schedule box.

grad.xlsm

any ideas?