F
frankjh19701
I'm trying to find a formula that will give me the lowest valu
according to some strange criteria.For example I have multipl
suppliers with multple prices and I need to deliver their goods fro
multiple locations with varying mileage to customers, with the lowes
costing carrier.For example I have multiple suppliers with multpl
prices and I need to deliver their goods from multiple locations wit
varying mileage to customers, with the lowest costing carrier.So, if
have this right - I need to find the cheapest product from the closes
location to the customer using the cheapest carrier. And I have to b
able to change the prices of the goods from each supplier and locatio
without changing the entire worksheet. Any/all ideas would be greatl
appreciated. Thank you
according to some strange criteria.For example I have multipl
suppliers with multple prices and I need to deliver their goods fro
multiple locations with varying mileage to customers, with the lowes
costing carrier.For example I have multiple suppliers with multpl
prices and I need to deliver their goods from multiple locations wit
varying mileage to customers, with the lowest costing carrier.So, if
have this right - I need to find the cheapest product from the closes
location to the customer using the cheapest carrier. And I have to b
able to change the prices of the goods from each supplier and locatio
without changing the entire worksheet. Any/all ideas would be greatl
appreciated. Thank you