Selecting a shipping box that best fits item dimensions

[weelrdeelr]

Alright you guys I usually have fun figuring these types of things out myself but it looks like this one may be a little too much for me. I need to determine the box that fits the item most effectively. I want to bump up the dimensions of the item by 1 each so I account for bubblewrap and padding, then put that item in the box that fits it best. For example, Item 1 would fit in Box 6 perfectly since after you bump up the dimensions by 1 it is exact. However, Item 2 could fit in numerous boxes. Box 4 would work best. Basically I want the least amount of empty space possible, after the bump up by 1. I messed around with the following general formula but couldn't quite get it right as I bet I'm missing a couple big components.

Also, the list of boxes will change. I'll be adding more and obviously taking some away as they are used. I also have multiple of the same box. Thank you so much you guys!!!!

{=INDEX(range1,MATCH(1,(A1=range2)*(B1=range3)*(C1=range4),0))}

Boxes.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Box #	L	W	H		Item #	L	W	H		Box # Needed	Expected Box #
2	Box 1	17	15	11		Item 1	5	5	3			Box 6
3	Box 2	12	12	11		Item 2	11	3	2			Box 4
4	Box 3	13	10	9
5	Box 4	13	5	4
6	Box 5	14	7	7
7	Box 6	6	6	4
8	Box 7	16	8	8
Sheet1

 

[AlanY]

how about?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Box #	L	W	H	Vol	Item #	L	W	H		Box # Needed	Expected Box #
2	Box 1	17	15	11	2805	Item 1	5	5	3			Box 6
3	Box 2	12	12	11	1584	Item 2	11	3	2			Box 4
4	Box 3	13	10	9	1170
5	Box 4	13	5	4	260
6	Box 5	14	7	7	686
7	Box 6	6	6	4	144
8	Box 7	16	8	8	1024
Sheet1

Cell Formulas
Range	Formula
L2:L3	L2	=INDEX($A$2:$A$8,MATCH(MINIFS($E$2:$E$8,$B$2:$B$8,">"&G2,$C$2:$C$8,">"&H2,$D$2:$D$8,">"&I2),$E$2:$E$8,0))
E2:E8	E2	=PRODUCT(B2:D2)

 

[weelrdeelr]

THANK YOU!!!

 

[AlanY]

THANK YOU!!!

you're welcome