Lookup Formula needed

[kingharvest]

Hi,

I'm trying to create a spreadsheet which calculates someones pay costs for a project. I've attached the workbook to help explain. But what i need it do is as follows:

In column B, you select the persons grade from a data valid list, and then in C you select whether or not you want to calculate their cost based on their Annual Salary or their Hourly Rate. THen depending on whether they choose, FTE or Hours the corresponding rate goes into column D. I've created the spreadsheet, and the data valid lists on a seperate sheet in the workbook, i just can't work out the formula to make it work.

Can anyone help?