variable list in drop down box

plato354 · Post by **plato354** » 05 Jan 2011, 20:29

I have an application where I need to change the contents of the drop down list in a cell based on the value of an adjacent cell. Does anyone know if this can be done? Thanks!

Post by **HansV** » 05 Jan 2011, 20:38

Welcome to Eileen's Lounge!

This can usually be done using INDIRECT, OFFSET or INDEX. Debra Dalgleish has useful pages on her website about this:
Excel Data Validation -- Dependent Lists
Excel Data Validation -- Dependent Dropdowns from a Sorted List
Excel Data Validation -- Dependent Lists With INDEX

plato354 · Post by **plato354** » 05 Jan 2011, 20:52

HansV,
That's exactly what I needed! Thanks much.
Plato354

agibsonsw · Post by **agibsonsw** » 05 Jan 2011, 21:05

HansV wrote:Welcome to Eileen's Lounge!

This can usually be done using INDIRECT, OFFSET or INDEX. Debra Dalgleish has useful pages on her website about this:
Excel Data Validation -- Dependent Lists
Excel Data Validation -- Dependent Dropdowns from a Sorted List
Excel Data Validation -- Dependent Lists With INDEX

The 2nd linked page has another one of those v. annoying 'download' images pointing towards google-ads.

They're not discreet are they, and there is nothing to download!

Post by **HansV** » 05 Jan 2011, 21:23

Yes, I noticed that...

Eileen's Lounge

variable list in drop down box

variable list in drop down box

Re: variable list in drop down box

Re: variable list in drop down box

Re: variable list in drop down box

Re: variable list in drop down box