product and quantity price break input into invoice

Hi,

I really didn't realise excel had the capability to do so much. Maybe I can learn more and people can show me step by step how I can get this to eventually work the way I want it to come out.

1st point:

- I have an invoice on 1 worksheet and the corresponding price on the other sheet
- each price has a quantity discount
- the corresponding price break should be reflected on the invoice when quantity is input

I'm not sure if this other point will work but:
-each item has a different price break based on quantity (ie product1 price break @ 50,100, 250 , product 1 price break @ 250 & 500) This is noted on the spreadsheet for claification.
- can some columns be left blank as in worksheet? or does each cell have to have a number filled it (example on sheet)

This forum IS AWESOME...I find people are very helpful and so I have learned more than I have ever learned on any other site. Very detailed.