Calculate shipping cost by entering weight

[nafijmoon]

I have an excel worksheet which has 3 sheets in total. This is the 2nd one.

And this is the 1st

I want a formula that will automatically take data from 2nd sheet (when I enter a weight in "Enter Weight LB" cell) and paste it on "Shipping Cost" cell by Zone of course. "Your Zone" cell is auto. It generates from 3rd sheet which I have no problem with.

If anyone can help it will be a world to me. Thanks in advance.

 

[Special-K99]

in Sheet1!D2
=INDEX(Sheet2!$B$2:$J$6,MATCH(A2,Sheet2!$A$2:$A$6,0),MATCH("Zone "&C2,Sheet2!$B$1:$J$1,0))

 

[nafijmoon]

in Sheet1!D2
=INDEX(Sheet2!$B$2:$J$6,MATCH(A2,Sheet2!$A$2:$A$6,0),MATCH("Zone "&C2,Sheet2!$B$1:$J$1,0))

OMG. Thanks a lot my friend. You just made my day. Really appreciate it.