Help: automatically fill in cells when entering certain data

Hi there,

First of all I would like to thank anyone who would take his time to read and try to solve my problem. Here it is:

I have table with names in column A and prices in column B in one worksheet. I would like to use that data in another worksheet of the same excel file when I put in names in column C of that worksheet. Lets say worksheet 1 with the table names and prices is: "repair prices" and
worksheet 2 name is: "service invoice".

Additional question for extra 100 karma points is: how to set excel autofil names from repair prices worksheet when I start entering them in service invoice?

Thanks!

Thanks a lot Olly. Your formulas totally work! You saved me a lot of time and hassle! +1000 to your karma!

Hi again!

I am back with more questions.
When I copy VLOOKUP formula to the rest of the blank cells in my table it shows #N/A and messes up my final sum formula at the end of the table, which is a bit frustrating. Life would be so much more fun if it wouldn't do that.

Thanks for your help!