davidfredc
New Member
- Joined
- Nov 24, 2008
- Messages
- 2
Ok this is somewhat tough, I consider myself to be handy with Excel and can't figure it out.
I have one sheet with 3 columns: Product name, raw material name, weight of raw material.
So in the first column you have the product listed several times for every raw material, then the weight of that raw material. I want to create another sheet with all the products as the header for the columns, and the raw materials on the side...I've done this but now I need a formula to populate this matrix with the weight values that correspond to the product and raw material.
I've tried a bunch of different 'if' / 'and' statements using array formulas. Pls help.
I have one sheet with 3 columns: Product name, raw material name, weight of raw material.
So in the first column you have the product listed several times for every raw material, then the weight of that raw material. I want to create another sheet with all the products as the header for the columns, and the raw materials on the side...I've done this but now I need a formula to populate this matrix with the weight values that correspond to the product and raw material.
I've tried a bunch of different 'if' / 'and' statements using array formulas. Pls help.