Hello,
I have a table which shows freight tariffs.
For an item I want to find the correct tariff when looking at the size and the weight of the product
In my example I have an article which is 14x10x1,5 in cm (lxwxh) with a weight of 480 gram.
Looking at the length and width the tariff in row 2 would fit. But because of the height the tariff will bump to row 3.
Then based on the weight row 8 is the one that fits all criteria. So I need to create some formula which looks at all criteria and picks the max row of one of the criteria which is the highest.
Bookmarks