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.


--
Thanks a bunch
Kim

Sounds like

=VLOOKUP(A2,Sheet2!B2:D100,MATCH(B2,Sheet2!$B$1:$D $1,0)+1,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kim" wrote in message
...
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.


--
Thanks a bunch
Kim