=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)



"Manny G" wrote in message
...
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?