Cell value depends on Combobox selection

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
 
B

Bob Phillips

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)
 
Top