match product id with product name from other workbook

I need help creating a function that will link one workbook to another. If you look at my two workbooks.


http://www.excelforum.com/attachment...1&d=1216415658

http://www.excelforum.com/attachment...1&d=1216415658

One workbook is a spreadsheet with a list of products and their I.D. numbers. It also includes their weight per unit.

The other workbook is a bill of lading that we use to ship our product. I want to be able to type in the I.D. number on attachment BOLtest2 in cell D14 and wherever else I have an ID number. These items change for each shipment. Also sometimes more product or less product will be added.

I want to be able to type that I.D. number in and when I hit enter have the name of the product that corrospondes to that ID number automatically pop up in cell E14. Also when that shows up, I want it to bring the weight per unit over from the flavor list workbook. I want it to then multiply that by the number of units that I am sending in B12 and calculate the weight in J12

Is this possible to do, if so how... Thanks for the help.