L
Lindsay
I have a spreadsheet with a size column, a price column and a quantity
column, along with others that are not relevant to my questions. Currently
when you select the size from a drop down list, the price automatically
populates from a corresponding list and then the price column is totaled.
However, i would also like to take into account the quantity column. So i
guess what I need it to do is:
When the user selects a size, the price for one piece is populated into
price column.
When the user enters a quantity, the price column is multiplied by the
quantity and the price column changes to the new price.
I sure hope this makes sense. Any help would be greatly appreciated
Oh ya, and currently I am using =VLOOKUP(B5,X$5:Y$33,2,0) to auto populate
the price column. And the quantity column is column H. Thanks!!!
column, along with others that are not relevant to my questions. Currently
when you select the size from a drop down list, the price automatically
populates from a corresponding list and then the price column is totaled.
However, i would also like to take into account the quantity column. So i
guess what I need it to do is:
When the user selects a size, the price for one piece is populated into
price column.
When the user enters a quantity, the price column is multiplied by the
quantity and the price column changes to the new price.
I sure hope this makes sense. Any help would be greatly appreciated
Oh ya, and currently I am using =VLOOKUP(B5,X$5:Y$33,2,0) to auto populate
the price column. And the quantity column is column H. Thanks!!!