• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparing the two lists and bringing the value from one list to another

For example- 614S090U01 is a Spare part kit, this kit has multiple items/components in it as shown below-

First screenshot I have number of kits sold in last three years, on separate sheet I have list of components in each kit, I want to add the components break down to the first screenshot sheet, how can I achieve it when the same component is used in more than one kit, for example, R-811 is used in '614S090U01 and '614S092U01, Please help! I have attached excel for your convince
View attachment 52970
 

Attachments

  • Test file_6.19.xlsx
    10.7 KB · Views: 3
Hi ,

When I try to open the attachment 52970 , I get this error message :

You do not have permission to view this page or perform this action.

Can you explain what kind of an output you need ?

Narayan
 
Back
Top