Need to get updated the workbook by update one function

[kvemperor]

In the first sheet i have the old inventory from the year that passed.there are 2 tables with the items that are been sold and in the cell n6 there is a function that is giving me individually the result.(the sums)
In the second sheet i have the new inventory that i want to make and i have made some alterations . I need to put also the unit price this time ,so I have put an extra column in both of the tables(header is writing unit price)
In cell p5 i have the new description at the extra column that i want to add, and in cell p6 i want to put the altered function(now this function is at cell q6).
i tried to modify the function by myself but i didn't make it.

[DJunqueira]

How to relate your inventory table if all CODE are '0000001'?

[kvemperor]

i have put random numbers not only 0000001 but i believe you can understand what i want to say

[AliGW]

No - your sample data MUST be REALISTIC.

[kvemperor]

It is realistic but i can understand what you are saying .i will put the original values and i will upload the sheet agai

[kvemperor]

This is the sheet with the prices.now i believe its realistic and you can understand what i mean

[Beamernsw]

Hi, try this in cell W6 copied down.

Please Login or Register  to view this content.

[DJunqueira]

I tried to resolve your issue with Power Query and ended up realizing that your database has duplication problems, which are highlighted in pink.