APFT_HTWT_ALPHA ROSTER_ROLL UP.xls

I need help, I am using Excell 2007 on a windows 7 OS. What I want to do is populate cells H and J on the sheet named Roll up Nov13 with data from the sheet named AR 600-9 Table 3-1 & 3-2 based on the data that is in cells D,Eand F on the Roll up Nov 13 sheet. any help would be appreciated. I have attached the woorkbook.

Thanks