Forum Discussion
Solved
Help with Complex Lookup using Lenght x Width x Height and Weight to Find Costs.
Help Excel Wizards! I am trying to find a formula that can pull fulfillment costs/fees from two tables for a product based on dimensions in inches (LxWxH) and weight. One table is fees for Hazmat...
Brian175 See attached, cells L3:Q3. I assumed each column is looked up independently and that subsequently the highest row is needed to take the price from.
Brian175 See attached, cells L3:Q3. I assumed each column is looked up independently and that subsequently the highest row is needed to take the price from.
JKPieterse This helps a ton! I'm going to play around with your method and see what I can come up with. That method seems like it will work but the way my table is set up is causing some issues. I will get back to you if I figure it out. Thank you!