If cell H2 is "=B2" I want cell I2 to be "=C2"

[LordLuciendar]

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.

[arlu1201]

The first part can be easily done (having column H cell show =B15). If you need the dropdown part to be done, you will need to use VBA.

Maybe you can attach a sample workbook so people here can spend more time to give you good quality solutions instead of creating a sample through guess-work.

[daddylonglegs]

Try using an INDEX/MATCH formula, e.g. in H2 copied down

=IFERROR(INDEX(B$2:B$100,MATCH(I2:C$2:C$100,0)),"")

For a dependant dropdown list you don't always need VBA, look at the techniques used here