Multiple cell as look up

I have a table (A) with columns material, color, and unit price
I have another table (B) that has many columns but also include material and color
How can I reference A’s unit price in B, using it in a math cell to calculate total cost by looking up both material and color from B in A.

Create a relation in table B between material and material. Add a query column that references the relation and uses color as a filter (you could simply just create a query column of the entire table and filter by both material and color color, but we’ve been told this is slower than starting off with a relation). Use a single value column, referencing the query to look up the unit price.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.