here's a tricky one for me, hopefully not for you.

I have a data table in one sheet which lists product numbers in the column, and materials used to make said product in the top row, with corresponding quantities where they meet.

In a second sheet, I have a daily list that consists what products were produced with a corresponding quantity produced in another column.

In my third sheet, I'd like to be able to see the totals of what materials were used that day depending on what products were produced

Ex. Daily sheet shows out of the list that 80 units of product 1 was produced. It takes 1 unit of material x to produce the product. Therefore Id like a formula to show me I used 80 units of material x, showing up under that column header.

Any help is appreciated, I feel like Im close but making it way too complicated and cant get it to work...

Thanks!