Assigning cost value to product no. so can be used in a sheet where product is repeating

[mannoqamar]

Hello people
I am new here and i hope i am posting the right question in the right place, apologies if not. I have a bill of material of parts and they are listed accordingly their assembly flowline process, which means the parts are being repeated over again and again in column. I filtered out the unique parts, to avoid duplication, in a separate sheet and assigned them their cost value in following column. Now i need to put their cost back into the original bom to workout the total cost because the parts are repeating in various processes and of different quantities. Is there anyway that i can do this logically otherwise i have to locate the part no in the bom and put cost value against it and the there are more than 2000 parts i am attaching screen shots of an example of what i have described above. Any help in this regard will be greatly appreciated. cheers


Capture.JPG

[hoyasaxa215]

Enter the formula below into E4 and copy down as necessary.

Please Login or Register  to view this content.

[mannoqamar]

Thank you so much you are a star.