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.

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.