I have been reviewing the VLookup function and set up but it is very
confusing to me so hopefully someone can help.

Sheet 1 - This will be the lookup sheet with range that can be edited if
more rows need to be added:
Code Description Price
111 stuff 13.00

On Sheet 2 I want to Enter the Code, find the code on sheet 1, and populate
the calculated Weight * Price and populate the Total field on Sheet 2
Sheet 2
Code Weight Total(the calculated field from lookup Sheet 1 price)
111 32164 (Price*Weight)

I figured out how to name the range on Sheet 1 so I called in Database.
I cannot get the formula right in Sheet 2 Total Column.