Excel - Dropdown question

[jlancton]

Hello,

I've got a workbook that is tracking Room rates. There are 8 Wings in the building. Four have one set of Room Types, the other four have a different set. Each Room Type has a particular Room Rate.

What I'd like is a dropdown with all the Wings. (I know how to do that). Then I'd like a second dropdown that would contain the Room Types based on the first dropdown. Then the third column would be the rate based on the previous two.

I've looked, but can't see a way to make one dropdown dependent on another like you can do in Access.

Any ideas??

Thanks,

-Jeff

 

[BlueHorizon]

Hi,

This link might help.

http://exceltips.vitalnews.com/Pages/T0915_Creating_Dependent_Drop-Lists.html

Best,
Blue Horizon

 

[xlbo]

a search of this forum for "Dependant dropdown" yields a few resaults, the 1st of which is:

thread68-1303582

which has a link to:

http://www.contextures.com/xlDataVal02.html

which should give you a very good starter for 10

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jlancton]

darn, should have searched... worse yet, I'd used this before and forgotten it. Thanks to both for showing the error of my ways.

My brain cramp continues however... Now I need to look at the two selections and determine a rate. Hmmm... search for dependent cell...

 

[xlbo]

Create a new column in your lookup table that concatenates the 2 options together - then do a lookup on that e.g. if DD1 in A1 and DD2 in A2 then

=vlookup(A1&A2,LookupRange,2,False)

should get you started

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question