My problem…… I have 2 columns. Cells A1 through Axx contain the product description. Cells B1 through Bxx contain the product cost. I can easily create a drop down showing the descriptions, but when I select the description (col. A), I really want to use the corresponding cost (col. B) to calculate the total product cost.

Think of it as making a pizza…… I select the product from col. A (crust, sauce, toppings, etc.) but I want to use the corresponding cost from col. B ($2.00, .65, .35, etc.)

How do I do this?!? Please help!