Create formula to choose price based on previous choice.
 

I'm working on creating a sales order document for photography. I want to be
able to have a column that automatically picks a price based on the dimension
of the print choosen. (i.e. 4 x 6 = 1.50, 5 x 7 = 2.00) That way clients
only pick the dimensions, but don't have to pick the price too.

Create formula to choose price based on previous choice.
 

I'd use another worksheet.

I'd put the valid sizes in column A (A1:A###)
And put the prices in column B (B1:B###)

Then use data|Validation to choose the size.
See Debra Dalgleish's site for some nice notes:
http://contextures.com/xlDataVal01.html

Then in the adjacent cell, I'd use =vlookup() to return the price for that size.

Say the cell with the size is B2, then in C2:
=if(b2="","",vlookup(b2,sheet2!a:b,2,false))

Debra has some notes for this function, too:
http://contextures.com/xlFunctions02.html

lindsielynette wrote:

I'm working on creating a sales order document for photography. I want to be
able to have a column that automatically picks a price based on the dimension
of the print choosen. (i.e. 4 x 6 = 1.50, 5 x 7 = 2.00) That way clients
only pick the dimensions, but don't have to pick the price too.

--

Dave Peterson

Create formula to choose price based on previous choice.
 

4x6 $1.00
5x7 $1.50

8 wallets $10.00
4x6 $7.00
5x7 $8.00
8x10 $12.00
11x14 $25.00
16x20 $75.00
20x30 $100.00

8x10 $20.00
10x30 $40.00
11x14 $40.00
12x12 $40.00
16x16 $40.00
16x20 $40.00
20x30 $60.00
20x40 $60.00
30x30 $90.00
30x40 $100.00

Those are my 3 data tables, but I don't understand the rest at all! I
really thought I was starting to figure out Excel. Anyway...so If I have one
column labeld "print size" with a drop down menu of the sizes, can I get a
2nd column labeled "individual price" to automatically choose the correct
price? I just want to make sure you understand me so I don't try and figue
all that out and find out it's not going to work for me...SORRY!

"Dave Peterson" wrote:

I'd use another worksheet.

I'd put the valid sizes in column A (A1:A###)
And put the prices in column B (B1:B###)

Then use data|Validation to choose the size.
See Debra Dalgleish's site for some nice notes:
http://contextures.com/xlDataVal01.html

Then in the adjacent cell, I'd use =vlookup() to return the price for that size.

Say the cell with the size is B2, then in C2:
=if(b2="","",vlookup(b2,sheet2!a:b,2,false))

Debra has some notes for this function, too:
http://contextures.com/xlFunctions02.html

lindsielynette wrote:

I'm working on creating a sales order document for photography. I want to be
able to have a column that automatically picks a price based on the dimension
of the print choosen. (i.e. 4 x 6 = 1.50, 5 x 7 = 2.00) That way clients
only pick the dimensions, but don't have to pick the price too.

--

Dave Peterson