Cell value depends on Combobox selection

  • Thread starter Thread starter sue4u
  • Start date Start date
S

sue4u

I'm trying to create a price list using combo boxes for the user t
select the number of items for each product.

For each product, the user has to choose the number of items via
combo box. The combo box is being filled from cells K1:K6 (through th
ListFillRange in the properties), the LinkedCell in order to hold th
selection output is M1. The various prices are listed in cells L1:L6.

What do I need to do in order to dynamically display the product pric
in a specific cell depending on the selection from the combo box?

Many thanks,
Su
 
Sue,

Sound like a job for Lookup.

=VLOOKUP(M1,$L$1:$L$6,2,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell value to populate based on changing value in another cell 1
Combo Box 5
Transpose technique not populating ListFillRange of ActiveX combobox 2
ComboBox for a range of cells 2
Create a RowSource Depending on ComboBox Choice 3
drop down selections 5
Bypass unlocked cell on protected worksheet in Excel 2003? 8
How to reference cell created from dropdown list in a combo box? 1

Back
Top