weight check to see price

[HellGuy]

I would like create a table where i can just input the weight and zone of the product and see it is cost.

I have weight ranges like; first two cloums are weight range and next 3 are the prices based on the zones.

31 40 5,70 ₺ 6,10 ₺ 6,50 ₺ 41 50 5,75 ₺ 6,25 ₺ 6,75 ₺ 51 60 6,35 ₺ 6,95 ₺ 7,55 ₺ 61 70 6,40 ₺ 7,10 ₺ 7,80 ₺ 71 80 6,45 ₺ 7,25 ₺ 8,05 ₺ 81 90 6,50 ₺ 7,40 ₺ 8,30 ₺ 91 100 6,55 ₺ 7,55 ₺ 8,55 ₺ 101 110 8,80 ₺ 9,90 ₺ 11,00 ₺ 111 120 8,85 ₺ 10,05 ₺ 11,25 ₺ 121 130 8,90 ₺ 10,20 ₺ 11,50 ₺ 131 140 8,95 ₺ 10,35 ₺ 11,75 ₺ <tbody> </tbody>

<tbody>
</tbody>

So i need the formula to check where the written weight in first two colums and check correct zone and bring up the right cost for that.

Can you help me on this one?

 

[HellGuy]

I got it sorted

=INDEX(!$E$1:$H$201;MATCH(C2;!$E$1:$E$201;1);MATCH(D2;!$E$1:$H$1;0))

 

[L. Howard]

Maybe this.

With your table in A3:E13.

A Drop Down in G1 with a list of 3,4,5

Hand type in the weight in G2.

And this formula in G3.

=IF(G2<31,"Below min wt.",VLOOKUP(G2,A3:E13,G1,10))

Type in the weight, and select the zone and the formula shows the cost.

Regards,
Howard

 

[vogel997]

		Zone	Zone	Zone
From	To	1	2	3
31	40	5.70 £	6.10 £	6.50 £
41	50	5.75 £	6.25 £	6.75 £		wheigt	zone	Price
51	60	6.35 £	6.95 £	7.55 £		140	3	11.75 £		=SUMPRODUCT((G5>=A3:A13)*(G5<=B3:B13)*(H5=C2:E2)*C3:E13)
61	70	6.40 £	7.10 £	7.80 £
71	80	6.45 £	7.25 £	8.05 £
81	90	6.50 £	7.40 £	8.30 £
91	100	6.55 £	7.55 £	8.55 £
101	110	8.80 £	9.90 £	11.00 £
111	120	8.85 £	10.05 £	11.25 £
121	130	8.90 £	10.20 £	11.50 £
131	140	8.95 £	10.35 £	11.75 £

<colgroup><col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" span="5"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"> <col width="64" style="width: 48pt;" span="3"> <col width="18" style="width: 14pt; mso-width-source: userset; mso-width-alt: 658;"> <col width="496" style="width: 372pt; mso-width-source: userset; mso-width-alt: 18139;"> <tbody> </tbody>