Excel pricing sheet

Microsoft Excel 2003 (full product)
July 12, 2010 at 11:24:11
Specs: Windows XP
I am trying to create a pricing sheet so when I use a combo box (which has all the drop down menus I would like to choose from) so that when I pick one of the products from first combo box then choose another option from second combo box it results in the proper pricing. I have created a table which i coded all products 1-40. The headings of the table are: Code, Product, P Group, and Price. So far for the products 1 through 20 that have P Group 1 it works because I'm guessing the P Group has not been integrated in the formula. I would like to make it so that when I change it to P Group 10 the price automatically updates. For example the first formula I used was =IF(H2=D28,G3,0). The cell H2 is the product, D28 is the cell linked to the combo box, G3 is the cell containing the code (first column in table), and the 0 is the value if false. Please help!!!!!

See More: Excel pricing sheet

Report •

July 12, 2010 at 13:19:26
HELP quick I'm waiting!!

Report •

July 12, 2010 at 13:39:58
re: HELP quick I'm waiting!!

Yeah, like that'll get us moving faster.

You know what? The only "quick" thing that's about to happen is your post getting deleted.

Office Forum Moderator

Report •

Related Solutions

Ask Question