Looking up a Number between a list

[Sorigel]

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.


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Min Weight[/TD]
[TD]Max Weight[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]200.00[/TD]
[TD]209.99[/TD]
[TD]$10[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]210.00[/TD]
[TD]219.99[/TD]
[TD]$12[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]220.00[/TD]
[TD]229.99[/TD]
[TD]$14[/TD]
[/TR]
</tbody>[/TABLE]

 

[bbott]

Assuming D1 as your lookup value cell:

=INDEX(A2:C4,MATCH(D1,A2:A4,1),3)

 

[CodeNinja]

That is a straight vlookup....
=VLOOKUP(A7,A2:C4,3)

CN

 

[Sorigel]

Exactly!!! Works perfect.. Why didn't i think of index.

Assuming D1 as your lookup value cell:

=INDEX(A2:C4,MATCH(D1,A2:A4,1),3)