ReneGe
asked on
Excel - Lookup tarif based on weight and Zone
Hi,
Please find attached the excel spreadsheet.
You will find two sheets. Tarif and Table.
In the Tarif sheet, I need to add the weight and the Zone Number, so that in B2, I get the Tarif.
I put an example of a tariff in the tariff sheet.
In that example, the weight is higher than 24 and lower than 50, and in zone 2. The expected calculated tariff is, therefore, $11.
I need to make a formula that will calculate the tariff automatically.
Thanks for your help,
René
Please find attached the excel spreadsheet.
You will find two sheets. Tarif and Table.
In the Tarif sheet, I need to add the weight and the Zone Number, so that in B2, I get the Tarif.
I put an example of a tariff in the tariff sheet.
In that example, the weight is higher than 24 and lower than 50, and in zone 2. The expected calculated tariff is, therefore, $11.
I need to make a formula that will calculate the tariff automatically.
Thanks for your help,
René
No attachment?
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brillant!!
Thanks Shums :)
You rock!!!
Thanks Shums :)
You rock!!!
You're Welcome Rene! Glad I was able to help :)