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.

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

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