Hi, sorry but the formula didnt work, it came back with a #n/a error, excel
shows the error as COL_INDEX_NUM. Sorry.

--
Kim


"B. R.Ramachandran" wrote:

Hi,

Try the following formula,

=INDEX(Sheet2!$A$1:$E$51,MATCH($C$27,Sheet2!$A$1:$ A$51,0),MATCH($C$29,Sheet2!$A$1:$E$1,0))

Note that the weight you enter in C27 (in Sheet 1) has an exact match in one
of the cells in A2:A51 of Sheet 2 (for example, you can not enter 50.8 lb in
C27, since Sheet 2 Column A will not have such an entry; so you should enter
it as 51 lb). To avoid this problem use ROUND($C$27,0) or ROUNDUP($C$27,0)
instead of $C$27 in the formula, depending on how you round off partial
weights, e.g., 51.2 lb as 51lb or 52 lb)

Regards,
B. R. Ramachandran

"Kim" 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
--
Kim