I have a price sheet with column B being prices for items and column C being item descriptions. I also have a quote builder in columns H and I which calculate totals of an order and different pricing tiers. Column H contains the prices which are added up, and column I is for the descriptions of the items.

All I want, is that when I enter in my I column for descriptions "=C15" for a certain item, that the corresponding column H cell will =B15. It takes a second to do this via copy and paste special, formula, but I want this to be automated so that there is less room for human error. How difficult can that be!

If you want to really amaze me, column A is a category for products, and column G tells which category the item should come from. If there is a way to make it so that each cell in column I is a drop down menu from which only the items for which the category in column A matches the category entry in column G.