Link to home
Start Free TrialLog in
Avatar of ReneGe
ReneGeFlag for Canada

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é
Avatar of Shums Faruk
Shums Faruk
Flag of India image

No attachment?
Avatar of ReneGe

ASKER

Oops!  Thanks :)
Here it is!
Cheers
Tarif_v1.0.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ReneGe

ASKER

Brillant!!
Thanks Shums :)
You rock!!!
You're Welcome Rene! Glad I was able to help :)