Forum Discussion

ElliotDT's avatar
ElliotDT
Copper Contributor
Jan 13, 2025

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.

Resources