Drop down list depending on previous values

You need depanted list for this.

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

hi OAKLEY. name your ChairSize range too. then do a Data Validation List formula as such:
=IF($B2="Bed",BedSize,ChairSize)

Is the bed size list the range B2:B8 on the Lists sheet?

What i suggested is this.

As the source for the drop down in column C use:

=INDIRECT(B2&C$1)

You don't have a named range that refers to the chair size yet so you'll have to create that named range.

Originally Posted by OAKLEY

thats great -
but sorry could i be a pain and ask how you entered it???

See in your List Sheet, headers in columns B & c.
Then see at the Named ranges. There are 2 more. Bed & Chair.
Then in Data validation rules in Column C, starting in C2, use this rule: = INDIRECT(B2)

Check this and let me know.

Apologize for my poor English.

I try to explain in the example that i upload.

But, pls someone that speak English, can explain to our friend what i have done?

You are welcome!

I am glad that at the end IS NOT "All Greeks for you"!

Typically, what you would do is name the range source for the drop down list the same as the item being selected from the parent drop down list.

For example, if the parent list selections are Bed and Chain then you create the named ranges Bed and Chair.

Bed would refer to: =Lists!$B$2:$B$8

Chair would refer to: =Lists!$C$2:$C$6

Then, as the source for the drop down list in column C you would use:

Data Validation
Allow: List
Source: =INDIRECT(B2)

............