G
Guest
Here is what I am trying to accomplish, I have a spreadsheet with multiple
pages of data (freight charges) what I want to be able to do is on the first
page enter a weight and a zone and have a formula give me the freight
costs from another page, on the second page there are multiple columns
with Column A being the weight starting at 1 and going up, Column B,C,D
etc have the weight cost related to each zone listed at the top of the column.
Can someone please please help me, I have tried everything and nothing
is working for me.
pages of data (freight charges) what I want to be able to do is on the first
page enter a weight and a zone and have a formula give me the freight
costs from another page, on the second page there are multiple columns
with Column A being the weight starting at 1 and going up, Column B,C,D
etc have the weight cost related to each zone listed at the top of the column.
Can someone please please help me, I have tried everything and nothing
is working for me.
100,MATCH(B2,Sheet2!$B$1:$D$1,0)+1,False)