Hi, I tried the formula and it didnt wok, it came back with an error #n/a
excel is saying the error is in the Col_Index_Num, I have no idea what that
means.

--
Kim


"Ron Rosenfeld" wrote:

> On Fri, 18 Nov 2005 17:23:03 -0800, Kim <Kim@discussions.microsoft.com> wrote:
>
> >Hi, I really hope someone out there can help me, I am trying to create a
> >formual
> >that will allow me to calculate freight charges. I want to be able to input a
> >weight and a zone and have it come back with the cost. This is basically
> >what the sheet looks like now,
> >Sheet 1 Cell C27 (Weight) 5
> >Sheet 1 Cell C29 (Zone) 51
> >Sheet 1 Cell C31-Formula
> >Now based on my data on sheet two using 5lbs and zone 51 should
> >make the answer $13.31. The weights from 1 to 50 are in Column A2:A51
> >on sheet 2 and the Zones are B1:D:1 and the charges are in Columns
> >B2:B51, C2:C51,D2:D51,E2:E51. None of the formulas I have tried work.
> >Can anyone out there help me with giving me the exact formula
> >I should use based on the information I gave to make this work
> >
> >I appreciate any and all help you can give me.
> >
> >Thanks alot
>
> I assumed that you would want the weight rounded up to the next pound, since
> that's how I usually pay freight.
>
> Given your data, and assuming that the Zones are in B1:E1 rather than as you
> wrote (B1:D:1), I think this formula should work -- but check them with your
> data:
>
> =VLOOKUP(CEILING(C27,1),Sheet2!A1:E51,MATCH(Sheet1!C29,Sheet2!A1:E1))
>
>
> --ron
>