Calculation of inventory value based on Columns 3 and 5 with missing recurring values
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.
