Microsoft Office Forums - View Single Post - [Solved] Compare sizes of different boxes and pick the correct size to put another box in to!

NBVC · 01-11-2018, 08:23 AM

I was afraid you were going to follow up with that question

Ok first insert a column for volume in column E and enter volumn formula:

Code:

=Product(B2:D2)

, remove spaces around the colon and then copied down

Then try this Array* formula:

Assuming your inputs have shifted over a column, now in K2:

Code:

=INDEX($A$2:$A$8,MATCH(1,($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2)*($E$2:$E$8=(MIN(IF(($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2),$E$2:$E$8)))),0))

*This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER before copying down.