Forum Discussion
Calculated column multiply with lookup table value
I have a transaction table and this is linked to a different table for product lookup. In the product look up, I have the price of each product. I want to make a new calculated column or measure...
If I imagine it right, you have a Quantity column in your Transactions table that you want multiplied by the Price in the Product table. I suggest you insert a Price column and a Total column in the Transactions table. Then, use a formula like this to the Price column:
=VLOOKUP(Product,ProductTable,
MATCH(Price,ProductLabels,0),0)
Finally, you simply multiply the values in the Quantity and Price columns to determine the values in the Total column.
=VLOOKUP(Product,ProductTable,
MATCH(Price,ProductLabels,0),0)
Finally, you simply multiply the values in the Quantity and Price columns to determine the values in the Total column.
