# Calculate shipping cost by entering weight

#### nafijmoon

##### New Member
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.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Special-K99

##### Well-known Member
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

##### New Member
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.

Replies
5
Views
96
Replies
4
Views
258
Replies
12
Views
291
Replies
5
Views
77
Replies
43
Views
2K

1,127,500
Messages
5,625,145
Members
416,075
Latest member
TechJosh

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back