Need to auto populate two fields

I have one cell that has a drop-down list (which I know how to do), and I am trying to get two other cells in my spreadsheet to auto-populate with set values based on the selection from the list.

For Example:

A B C D
8860 68.79 3500 203.69
5250 77.59 3500 203.69


If the column A's are pulled from a drop-down, I would like B & C to auto populate those numbers, and D will calculate based on the total values. I have all the values on another spreadsheet.

Maybe this link will be helpful.

http://www.youtube.com/watch?v=Ko68RF89JVk