Multiple suppliers, criteria choose the correct supplier according to the parameter given

[ryan2355]

So for example i Have three suppliers for a given delivery depending on weight to point "A" to "B"


From To AA pallet AA semi AA fullload BB pallet BB semi BB fullload CC pallet CC semi CC fullload
A B 1 2 3 4 3 4 2 3 4
A C 2 3 4 3 4 5 3 3 4

Given weight parrameters that

min max mode
0 < 4 pallet
4 =< 6 semi
6 =< 12 fullload


now I need a a table like this

WEight From to Mode Cheapest supplier price
4 A B formula formula formula

Please help this is urgent

Thank u in advance

[hemesh]

Hello and Welcome to the forum Ryan Can you please upload a sample book with enough data work with !

to attach go to advance->select paper clip icon or manage attachment

[ryan2355]

Hello hemesh,

I have attached the document along so you know what im expecting and have given the formulas I need to perform

Thank you in advance