Can I do this?

M

Manny G

I have this enormous spredsheet of rates: on to I have the weigh on the
column I have the states, on the center I have the rates according to the
state and weight.
because is so big, I created a drop-down from the STATE for me to pick the
State the second is a dropdown for the weight, Now once I pick the State and
The waight from the drop-dons I want to automatically show on the next cell
the value corresponding to the value in the chart for the rates I created. Is
that posible?
 
B

Bob Phillips

=INDEX(M1:M20000,MATCH(1,(A1:A20000=state_dd_value)*(B1:B20000=weight_cell_value),0)

this is an array formula, so commit with Ctrl-Shift_enter, not just Enter

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Manny G

Manny G said:
I have this enormous spredsheet of rates: on to I have the weigh on the
column I have the states, on the center I have the rates according to the
state and weight.
because is so big, I created a drop-down from the STATE for me to pick the
State the second is a dropdown for the weight, Now once I pick the State and
The waight from the drop-dons I want to automatically show on the next cell
the value corresponding to the value in the chart for the rates I created. Is
that posible?
EXAMPLES
Click to expand...

DELIVERY STATE WEIGHT RATE
MICHIGAN 20000 - 24999

tHE SPREADSHEET

MIN CHARGE 0 - 4999 5000 - 9999 10000 - 14999
ALABAMA $283.25 $ 0.14 $0.12 $ 0.11

ARIZONA $339.90 $0.18 $0.15 $0.14
COLORADO $339.90 $0.18 $0.15 $0.14
CONNECTICUT $226.60 $0.10 $0.08 $0.08
DELAWARE $226.60 $0.10 $0.08 $0.07
FLORIDA $283.25 $0.11 $0.10 $0.09 $0.08 $0.07
TALLH./WEST $339.90 $0.14 $0.12 $0.11 $0.09 $0.07
GEORGIA $283.25 $0.11 $0.10 $0.09 $0.08 $0.07
THOMASVILLE/ALBANY $283.25 $0.14 $0.12 $0.11 $0.09 $0.07
 
Top