Hi Excel Experts!
So what i am trying to do is quite beyond my knowledge.
What i want to do, is to make a freight calculator, which means i have a matrix where Weight is defined in rows and freightzones are defined in columns, in each intersection there is a price.
Weight is not a set definition, but are intervals. This means, that if a package weighs 1360gram it is in the interval 1100g to 2000g.
So my matrix looks like this:
<tbody>
</tbody>
This matrix is placed in a tabel called "DHLEconomy"
Then i have another sheet called "Beregner" where i have two inputs: "Weight" and "freightzone" placed in cell B3(weight) and D3(freightzone)
What i need to do, is to make a lookup-statement, which will find the correct price, by finding the row where the "Weight" is within the correct interval, and where the column is equal to the freightzone.
So what i am trying to do is quite beyond my knowledge.
What i want to do, is to make a freight calculator, which means i have a matrix where Weight is defined in rows and freightzones are defined in columns, in each intersection there is a price.
Weight is not a set definition, but are intervals. This means, that if a package weighs 1360gram it is in the interval 1100g to 2000g.
So my matrix looks like this:
Weight (min) | Weight (max) | Zone 1 | Zone 2 |
0 | 1000 | 52 | 74 |
1001 | 2000 | 104 | 148 |
<tbody>
</tbody>
This matrix is placed in a tabel called "DHLEconomy"
Then i have another sheet called "Beregner" where i have two inputs: "Weight" and "freightzone" placed in cell B3(weight) and D3(freightzone)
What i need to do, is to make a lookup-statement, which will find the correct price, by finding the row where the "Weight" is within the correct interval, and where the column is equal to the freightzone.