Stock Storage Find The Right Location For Each Item

[Seifeddine87]

Hi am trying to put set or rules for my stock in storage
i have got different sizes storage room and different sizes items
i have made a set of rules of my items
example any item less then
10-8-8cm = 640 cm cube (Group 1 )
20-10-10cem = 2000 cm cube (Group 2 )

and the storage name and size
A1 = 40-30-30 = 36000 cm cube
A2 = 50-30-30 = 45000 cm cube

A3 = 40-30-30 = 36000 cm cube
A4 = 40-30-30 = 36000 cm cube

	A	B	C	D	E	F	G	H	E
1	Location Name	Totale	Used	Free
2	A1	36000	35999	1		Group 1		Group 2
3	A2	45000	40000	5000		A1		A3
4	A3	36000	30000	6000		A2		A4
5	A4	36000	30000	6000
6
7	Group Name	L	W	H		Cm Cube
8	G1	10	8	8		640
9	G2	20	10	10		2000

<tbody>
</tbody>

10	Product code	L	W	H	Cm Cube	Group	Loction
11	500	9	7	6	378	G1	A2
12	501	19	9	9	1539	G2	A3
13	503	19	9	9	1539	G2	=.......
14

<tbody>
</tbody>

i want a formula to give me the right storage location
thank you

 

[Seifeddine87]

hi i have just noticed that their has been views but no reply. I am just wondering if it makes sense what I am asking or if it is to complicated. If someone understands what i am asking and has any suggestion or a different way