A simple excel formula problem that requires support from experts!

[Mr Kaka]

Hi,

I need your help in creating an excel formula that solve the following problem:

I need a formula that allows me to find the size of the smallest box that can contain a certain number of products.

On C10, I input the number of units, whereas on C13:C16 is where I would like to get the output.
On C6:C8 I reported the size of the product.
On I4:L15, I reported the available boxes.

Here you can see my worksheet:

Book2
	A	B	C	D	E	F	G	H	I	J
1
2
3		Product Dimension					Type of boxes
4		Longest side (cm)	20			ID	Longest side (cm)	Median side (cm)	Shortest side (cm)
5		Median side (cm)	8			1	20	20	10
6		Shortest side (cm)	6			2	20	20	20
7						3	30	20	20
8		Units				4	30	30	20
9						5	35	30	15
10		Box				6	35	29	19
11		ID				7	40	30	30
12		Longest side (cm)				8	43	35	31
13		Median side (cm)				9	50	37	32
14		Shortest side (cm)				10	50	40	40
15						11	60	40	40
16
Sheet1

Cell Formulas
Range	Formula
F6:F15	F6	=F5+1

 

[Stiped]

Hey DanteAmor,

I'm trying to find the best fitting box for my products and I can't seem to configure your formula to work off of multiple sheets. Can you help with this?