Calculate shipping cost by entering weight

nafijmoon

New Member
Joined
Mar 26, 2019
Messages
4
I have an excel worksheet which has 3 sheets in total. This is the 2nd one.

6AJJ8iX.png


And this is the 1st

fKRCPJ5.png


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.
 

Some videos you may like

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
Joined
Nov 7, 2006
Messages
8,350
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))
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top