Populating cells by selecting items from Combo Box? How to?

  • Thread starter Thread starter mwd
  • Start date Start date
M

mwd

I have a combo box with three different house models. I need th
spreadsheet to show the square footage of each side of the house fo
each model when it is selected from the combo box.

Basically I have four cells in a column, Side 1, Side 2, Side 3,Side
for each side of the house. Then, next to each of those cells I woul
like the values of the square footage to show up when that particula
house model is selected from the combo box (the square foot #s ar
always the same and can be inputted beforehand)

I'm not sure if there is a way to do this without using much code(don'
have much knowledge on how to do this).

I've attached the example I have so far...

thanks,
Mar

Attachment filename: house.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46405
 
Marc,

I'm not going to open your attachment, but I can tell you how to do what you
want just based on your description.

The usual way is to use data validation on your input cell, let's say A1.
Use Data | Validation... Allow "List", and use your house names as your
list source:

House1,House2,House3

Then you can use any number of different formulas - here's one:
=CHOOSE(MATCH(A1,{"House1","House2","House3"}),1000,2000,3000)

Of course, you'll need to use your own house names and square footage.

HTH,
Bernie
MS Excel MVP
 
Hi

Add a worksheet p.e. Models with a table in it:
Model, Side1, Side2, Side3, Side4
and enter your models and according square footage for every side into it.

Create named ranges
Model=OFFSET(Models!$A$2,,,COUNTIF(Models!$A:$A,"<>")-1,1)
Models=OFFSET(Models!$A$2,,,COUNTIF(Models!$A:$A,"<>")-1,5)

I don't know what kind combo you are using at moment, but you can use data
validation list. On sheet with your table, select the range (3 cells did you
say?) where you want models select, and then Data.Validation.List with
source as
=Model

The formula for first side's square roots for model in cell A2 will be
=VLOOKUP($A2,Models,COLUMN(B2),FALSE)
Copy the formula to range for areas to return
 
Back
Top