Excelproblem - Is this possible??

[manythanks]

I am doing a list off all items I want to sell in a webshop in the future that customers will be able to download, I`ll try to explain the problem:

I have columns that represents cost for item, weight for item, packageweight for item.

When they have marked what items they want and what quantity it is collected as a totalprice in a cell futher down and the total weight incl packageweight is also included in the totalweightcell futher down.

I also have 4 ways off shipping: EMS, AirMail, SAL and Surface.
I have all shippingprices for each off them and what I want is somehow make excel calculate depending on the total weight the total price for shipping. Is this possible? I do not want any visual basic.

If it is hard to understand my explination please let me know.

[NBVC]

You can incorporate a Vlookup() function that will select the shipping price based on the shipping method.

for example if X1:Y4 contain the shipping methods with corresponding price/pound...

then: =D2*Vlookup(E2,$X$1:$Y$4,2,0) would multiply D2 (weight) by $/lb based on shipping method input in E2....

[manythanks]

Please look at attched file. I am not good at excel .

[NBVC]

Have a look at the attached.

I have had to include a hidden row of 0 values for each table.

I also converted all table entries to numeric values so that I can work with the table.....it is hopefully understood the currency is Yen (you can put that in the table name).