I did not know how to title what I am trying to do without showing the data directly. I am trying to use a formula to choose a container code based on the dimensions of a container. This is currently a manual process which takes forever. The data below should give an explanation of my criteria and choices.
<colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 11154;">
<col width="190" style="width: 143pt; mso-width-source: userset; mso-width-alt: 6948;">
<col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;">
<tbody>
</tbody>
These are just 3 of my choices. In this scenario a container that is 45" x 32" x 25" would classify as a 121 because its length, width, and height do not exceed the dimensions in the 2nd column. All of my length, width, and height options are below. The data being measured would be 3 cells (a length, a width, a height). All of my lengths, widths, and heights available are below. Please help!
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Description | Dimensions | Code Printed on Container Tag |
Cardboard box / pallet combination Equal (or not to exceed) | 48" x 34" x 27" | 121 |
Cardboard box Equal (or not to exceed) | 32" X 30" X 25" | 126 |
Cardboard box / pallet combination Equal (or not to exceed) | 48" x 39" x 34" | 131 |
These are just 3 of my choices. In this scenario a container that is 45" x 32" x 25" would classify as a 121 because its length, width, and height do not exceed the dimensions in the 2nd column. All of my length, width, and height options are below. The data being measured would be 3 cells (a length, a width, a height). All of my lengths, widths, and heights available are below. Please help!
Lengths | Widths | Heights |
5.5 | 5.5 | 5 |
11 | 7 | 6 |
12 | 11 | 7 |
24 | 15 | 8.375 |
32 | 22 | 9 |
38 | 30 | 11 |
48 | 32 | 25 |
52 | 32.5 | 27 |
54 | 38 | 32.5 |
64 | 39 | 34 |
70 | 45 | 36 |
72 | 48 | 39 |
108 | 52 | 43 |
44 | ||
48 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>