VLOOKUP conversion formula help

See attached Excel Workbook.

I'm using VLOOKUP to find a formula to convert currency/Unit of Measure. VLOOKUP finds the currency/UoM name in another sheet within workbook and then picks up the conversion calculation that then refers back to sheet 1 to plug in a value to convert. The formula in attached file works but when the formula in cell D1 in 1st sheet is coppied down it doesnt use the correct value in column B for record being pasted to. If you follow the formula in Sheet 1 cell D2 you should be able to follow what is being attempted. Using the absolute/relative symbol doesnt see to work. Columns H-I should be ignored

All help is appreciated.