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?

SKU	Product	Shipping Template	Shipping price
1234	ABC	Small Box
5678	DEF	Medium Box

<tbody>
</tbody>

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)