[Darren[_3_]]

I have designed an electronic order form that allows the
customer to select a product (from a drop down box) and
enter the quantity required. Once the product combo box
loses the focus the next cell is supposed to calculate the
costs of the items i.e. Total Cost = Price of Product
selected * Quatity.

In column B7 to B25 is the name of the product and in
column C7 to C25 is the price of that product. What
combination of formulas would instruct Excel to get the
price that corresponds with the product selected in the
combobox and complete the calculation?

Cheers,
D

[Leo Heuser[_2_]]

Hi Darren

Assuming the cell link of the combobox is B2,
this formula will calculate the price:

=INDEX(C7:C25, B2)*Quantity

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.

"Darren" skrev i en meddelelse
...
I have designed an electronic order form that allows the
customer to select a product (from a drop down box) and
enter the quantity required. Once the product combo box
loses the focus the next cell is supposed to calculate the
costs of the items i.e. Total Cost = Price of Product
selected * Quatity.

In column B7 to B25 is the name of the product and in
column C7 to C25 is the price of that product. What
combination of formulas would instruct Excel to get the
price that corresponds with the product selected in the
combobox and complete the calculation?

Cheers,
D