Assembly Cost

I am trying to see if I can get some help. I am making some final assemblies using multiple sub parts, SheetA. Each assembly is different and uses different parts, SheetB.

On SheetA, I have A5=quantity, B5=part, and C5=total price. On SheetB, I am using columns A and B for reference parts and price. A=parts and B=price.

So I am wanting SheetA C5 to look at SheetA B5 and see what is needed then look at SheetB A3 thru A40 to find the item then multiply SheetA A2 by the parts price from SheetB column B.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try this - (let me know if you want the colors):

Please Login or Register  to view this content.

You're welcome!

BTW - did I guess your nickname?

Tee Hee