Match Box size to order based on volume (Like a true/range vlookup)

Question

Hi,

I am trying to match a box size to an order based on volume. I have a lower and upper range of volume for each box size. And I'm basicly trying to do a range vlookup to pull the ideal box size onto each order, and match it with the SKU volume. I have attached pictures of my data. Please let me know your suggestions. Thank you!

If you could build a quick example workflow that would be amazing, thank you!

Box Sizes.PNG

SKU Volume.PNG

lmorrell · Accepted Answer

Hi @AustinBauer

Solution is attached.

One way to do this is by appending every box type to every order number to create every scenario of box being paired with the order. From there you can use a filter specifying that the total volume is less than the upper limit AND that the total volume is less than the lower limit to return one row per order - as this condition should only be true once.

[Sum_SKU Volume] <= [Target volume - Upper range] AND [Sum_SKU Volume] >= [Target volume - lower range]

Hope this helps!