Forum Discussion
ElliotDT
Jan 13, 2025Copper Contributor
Formula Help Required - Packaging Spreadsheet based on Type.
Good Morning,
I am struggling to create a formula to provide a total weight for a packaging spreadsheet (Image attached).
I need to create a spreadsheet which provides total weight depending on a part number and the packaging specs. I have packaging types and the relevant weights. Then dependant on the part number I have a qty of packaging.
For reference, Part number A1234 uses packaging type H, height 1. This means I need 1 H Lid, 1 H Pallet and 1 H Collar. The formula needs to see the packaging Type H then use the weights in this type based on the packaging qty?
Please can anyone provide help on this?
In J3:
=MMULT(E3:H3, INDEX($B$12:$E$15, 0, XMATCH(B3, $B$11:$E$11)))
Fill down.
In J3:
=MMULT(E3:H3, INDEX($B$12:$E$15, 0, XMATCH(B3, $B$11:$E$11)))
Fill down.
- ElliotDTCopper Contributor
Thank you for your help!