functions/formulas to find Total Cost to Purchase and time to repay what to use?

[idonovan]

hi all im working on an excel project for school and i am stuck on some things I will copy and past the instructions and screen images.

In cell G4, you are asked to calculate the total amount of money that has been spent to purchase the property. Note: this is a formula, not a function, and must include absolute cell references and must take into consideration any money spent on the acquisition of the property.
(this should be the fist screen image) i put somthing in g4 but i dunno if this is correct =(B$25/12)*(B$26*12)*B4 is the formula i used. b25=7% b26=25 years... b4 is the morgage amount 599995 so is this the right formula?

this is the next question and should be the next sceen image
use the Reference Tables sheet to look up the names of the supervisor for each department and display the results in column D. An exact match and absolutes are required in this function.

here i have no clue what to do... vlookup maby? what do i enter into the formula though??

[royUK]

There's not much point attaching images - a workbook would be better. Also as this is homework show what you have tried

[idonovan]

im not sure how to do a workbook still need help as this is due tommorow gahhh and 3 other ppl are relying on a good grade