I have a list with three columns. One has the min weight and the other the max wieght. I want to find the easiest way to return a value on a third column cost.
So if i were to enter 221 it would return $14. I found a similar problem with a vlookup solution but that lookup value was one or the other in columns a or be. In my example however the look up value might also fall in between.
<tbody>
</tbody>
So if i were to enter 221 it would return $14. I found a similar problem with a vlookup solution but that lookup value was one or the other in columns a or be. In my example however the look up value might also fall in between.
A | B | C | |
Min Weight | Max Weight | Cost | |
1 | 200.00 | 209.99 | $10 |
2 | 210.00 | 219.99 | $12 |
3 | 220.00 | 229.99 | $14 |
<tbody>
</tbody>