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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Location Name[/TD]
[TD]Totale[/TD]
[TD]Used[/TD]
[TD]Free[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A1[/TD]
[TD]36000[/TD]
[TD]35999[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]Group 1[/TD]
[TD][/TD]
[TD]Group 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A2[/TD]
[TD]45000[/TD]
[TD]40000[/TD]
[TD]5000[/TD]
[TD][/TD]
[TD]A1[/TD]
[TD][/TD]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]A3[/TD]
[TD]36000[/TD]
[TD]30000[/TD]
[TD]6000[/TD]
[TD][/TD]
[TD]A2[/TD]
[TD][/TD]
[TD]A4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]A4[/TD]
[TD]36000[/TD]
[TD]30000[/TD]
[TD]6000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Group Name[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]H[/TD]
[TD][/TD]
[TD]Cm Cube[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]G1[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]640[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]G2[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD]Product code[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]H[/TD]
[TD]Cm Cube[/TD]
[TD]Group[/TD]
[TD]Loction[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]500[/TD]
[TD]9[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]378[/TD]
[TD]G1[/TD]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]501[/TD]
[TD]19[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]1539[/TD]
[TD]G2[/TD]
[TD]A3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]503[/TD]
[TD]19[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]1539[/TD]
[TD]G2[/TD]
[TD]=.......[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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