Hello NBVC,

Than you so much for your reply. It is a brilliant formula and very nearly does everything I want from it. However, I want it with a cherry on top ;-)

Is there any way it can pick the smallest possible box overall? I can put in a volume equation for the product box and the shipping box if that helps at all.

Once again, thank you so much for your work so far

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: , 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.