Assign a cell a specific value

[i8ur4re]

Hi,

I'm not sure if i have the correct title on this thread, here is what i am trying to achieve.

I have 4 shipping templates.

1. Flat Rate Envelopes
2. Small Box
3. Medium Box
4. Large Box

I also have an excel sheet that has products, each product has one of those shipping methods above.

Ex:

Blue stripped socks > Flat Rate Envelope
Blue Stripped Shoes > Medium Box
etc
etc..

For Flat rate envelope, shipping costs 6.95
Small Box = 7.80
Medium Box = 11.20
Large Box = 17.90

How do i assign the value so in a separate cell, it will give me the price?

[TABLE="width: 500"]
<tbody>[TR]
[TD]SKU[/TD]
[TD]Product[/TD]
[TD]Shipping Template[/TD]
[TD]Shipping price[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]ABC[/TD]
[TD]Small Box[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5678[/TD]
[TD]DEF[/TD]
[TD]Medium Box[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I would like shipping price to be auto filled when shipping template specifies a value

 

[kweaver]

If I understand you correctly, this is a VLOOKUP. From the below, you can decide where you want the rates and the product listings.

Excel 2010
	A	B	C	D
1	Flat Rate	6.95
2	Small Box	7.80
3	Medium Box	11.20
4	Large Box	17.90
5
6
7	SKU	PRODUCT	Shipping Template	Shipping Price
8	1234	ABC	Small Box	7.80
9	5678	DEF	Medium Box	11.20
Sheet2

Cell Formulas
Range	Formula
D8	=VLOOKUP(C8,$A$1:$B$4,2,FALSE)