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.

Hi,

Does the attached help?

Regards

L19: =IF(ISERROR(VLOOKUP($D19,Data,2,0)),"",INDEX(Product!$A$2:$F$11,MATCH(Invoice!$D19,Product!$A$2:$A$11,0),MATCH(Invoice!$C19,Product!$B$1:$F$1,1)+1))

and copy down.

You'll need to fill in the gaps where you currently have no values.


Regards

If you pose a question in the forum, it's generally a good idea to keep track of it by logging in and looking at your subscribed threads (click User CP).

Clearly, the requirement was not urgent

However, you have merged cells, so, without restructuring your invoice, there's nowhere to put the description.

Assuming you do restucture ... split the cells ... it's just a simple VLOOKUP, as you had originally.

Regards

how do I close thread as solved?

See my signature for details or the FAQ.