How do I look up a value in a table with 2 criteria?
 

What formula should I use to look up the value in this table if I have a zip
code and weight of a package? I know to use lookup, but am unclear on where
to put what.
A B C D
E F
1 0-9999 10000-19999 20000-29999 30000-39999 40000-49999
2 0 $13.35 $13.00 $12.66 $12.32 $12.00
3 500 $13.11 $12.78 $12.45 $12.14 $11.83
4 1000 $12.87 $12.56 $12.25 $11.95 $11.66
5 2000 $12.63 $12.34 $12.05 $11.77 $11.49
6 5000 $12.40 $12.12 $11.85 $11.58 $11.32
7 10000 $12.40 $12.08 $11.76 $11.45 $11.15
8
9 Zip Code
10 Wieight of Shipment

20000 $11.98 $11.72 $11.47 $11.22 $10.98
30000 $11.70 $11.47 $11.25 $11.03 $10.81

What do the values 0-9999, etc mean: zip codes or weights?

jmalies wrote:
What formula should I use to look up the value in this table if I have a zip
code and weight of a package? I know to use lookup, but am unclear on where
to put what.
A B C D
E F
1 0-9999 10000-19999 20000-29999 30000-39999 40000-49999
2 0 $13.35 $13.00 $12.66 $12.32 $12.00
3 500 $13.11 $12.78 $12.45 $12.14 $11.83
4 1000 $12.87 $12.56 $12.25 $11.95 $11.66
5 2000 $12.63 $12.34 $12.05 $11.77 $11.49
6 5000 $12.40 $12.12 $11.85 $11.58 $11.32
7 10000 $12.40 $12.08 $11.76 $11.45 $11.15
8
9 Zip Code
10 Wieight of Shipment

20000 $11.98 $11.72 $11.47 $11.22 $10.98
30000 $11.70 $11.47 $11.25 $11.03 $10.81