Forum Discussion
Solved
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 ...
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.
Thank you for your help!
