Prev: Formula Help
Next: Retrospective Cell Naming
From: sk on 7 Apr 2010 21:43
Thank you indeed. This was really helpful.
--


"T. Valko" wrote:

> We can all thank Debra for having such an awesome website!
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Mossykel" <Mossykel(a)discussions.microsoft.com> wrote in message
> news:72676933-8692-4F5E-8D35-54515E7F43FB(a)microsoft.com...
> > Worked wonderfully! Thanks a million!
> > --
> > KM
> >
> >
> > "T. Valko" wrote:
> >
> >> See this:
> >>
> >> http://contextures.com/xlDataVal02.html
> >>
> >> --
> >> Biff
> >> Microsoft Excel MVP
> >>
> >>
> >> "Mossykel" <Mossykel(a)discussions.microsoft.com> wrote in message
> >> news:A807180E-4E80-4E83-A800-4593AE073D99(a)microsoft.com...
> >> >I am trying to do cascading drop-down lists in excel so that when I
> >> >select
> >> >my
> >> > choice from my first list, only information pertaining to that choice
> >> > shows
> >> > up in the second drop down list. Example: selecting a type of wood
> >> > for a
> >> > floor in a first drop-down list one expects only the colors available
> >> > for
> >> > the
> >> > type of wood selected to show in the second drop-down list not all the
> >> > colors
> >> > of all the types of wood.
> >> >
> >> > The problem I am having is that I have more than 8 primary and
> >> > secondary
> >> > lists and am not able to do my =if() function in the 'source' area of
> >> > the
> >> > data/validation. I've read about using index/match formulas or by
> >> > using a
> >> > UDF but am unsure as how to do either of these... a little help?
> >> >
> >> > --
> >> > KM
> >>
> >>
> >>
>
>
>
 | 
Pages: 1
Prev: Formula Help
Next: Retrospective Cell Naming