Calculation of inventory value based on Columns 3 and 5 with missing recurring values

[Citris]

Hello everyone,

I need your help with a formula.

• Column 3 displays the stock quantity per item and location.
• Column 4 shows the last average price by location.
• Column 5 shows the last average price by item.

I need to calculate a column for the inventory value based on Column 3 and 5. The problem is that the values in Column 5 do not repeat for all rows.

In Column 6 and 7, I attempted to create the formula. In row 3, you can see that it outputs the wrong value, as it calculates 109 * 23.87 instead of 109 * 24.08.

I hope you can assist me with this.

Best regards,

Citris