I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value
The look up table looks like this: (example)
kg value 0 2.00000000000000000000 160.5 2.35000000000000000000 195.5 2.55000000000000000000 220.5 2.75000000000000000000 245.5 2.83000000000000000000 270.5 2.89000000000000000000 295.5 2.92000000000000000000 320.5 2.95000000000000000000 345.5 3.00000000000000000000 445.5 2.35000000000000000000
so in my case, (212.5kgs) I need to return the value of 2.55 as 212.5kgs is between 195.5 and 220.5
can anyone help how I can do this please?
Kind regards Harry
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.