Automate customer invoice by product, qty ordered to calc discount applicable

Hello,

I'm trying to assist a colleague with automating a customer invoice by matching a part number from one worksheet to another and then calculate the amount $ based on quantity ordered from the second worksheet.

Im not sure if the attachments make sense?


I tried a index, match, match but had to change the way the catalogue table looked and I would prefer to keep the table like the attached example if possible.

So any help would be greatly appreciated.

Example.xlsx

Hi Spike,

Welcome to the forum.

Try using below formula in H5 and drag down:-

Formula:

Please Login or Register  to view this content.

Enter it using ctrl shift enter key combination.

See attached:-Example(31).xlsx

Regards,
DILIPandey
<click on below * if this helps>