Hi guys,

Have a bit of an issue. So I have determined what category a product I am selling is based on other metrics. I also know the weight of the product. Using a table of data that has the various categories, the maximum allowed weights within each category and the associated fee, I would like a formula that when I enter the category and weight of a product, it will tell me the correct fee. Attached is the table I want to use as a lookup.

Thanks

AdamFees.xlsx