Returning Value from range array

[gregz12345]

Hello,

I'm looking to inquire about how to return a country's cost, based on a given weight.

The issue is that the weights I'm looking up against have predesignated weight breaks, the given weights ('B' below) may fall between the range.

I'm ultimately looking to return the rounded up value.

EG: weight .332 lbs for UK should return $4.74

Thank you!




A

Weight (lb)	Canada	United Kingdom
0.0625	$3.41	$3.21
0.1250	$3.64	$3.52
0.1875	$3.88	$3.82
0.2500	$4.12	$4.13
0.3125	$4.36	$4.43
0.3750	$4.59	$4.74
0.4375	$4.83	$5.04

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

B

0.332	United Kingdom
0.334	United Kingdom
0.349	United Kingdom
0.354	United Kingdom
0.356	United Kingdom
0.359	United Kingdom
0.381	United Kingdom
0.385	United Kingdom
0.397	United Kingdom
0.398	United Kingdom
0.398	United Kingdom

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[steve the fish]

Re: Help Returning Value from range array

With a weight in E1 and country in F1 try:

=INDEX($B$2:$C$8,MATCH(1,INDEX(--($A$2:$A$8>=E1),0),0),MATCH($F1,$B$1:$C$1,0))

 

[gregz12345]

Re: Help Returning Value from range array

With a weight in E1 and country in F1 try:

=INDEX($B$2:$C$8,MATCH(1,INDEX(--($A$2:$A$8>=E1),0),0),MATCH($F1,$B$1:$C$1,0))

Thanks!