Make input in one column determine dropdown list in another.

Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?

Use a list formula of the type

=OFFSET(IF(E1=1,rng1,rng2),0,0,(COUNTA(IF(E1=1,rng1,rng2))),1)

where E1 is the first DD.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gettin-older" <gettin-older@discussions.microsoft.com> wrote in message
news:8FF90B6B-F07F-402B-A042-E1B103C40EED@microsoft.com...
> Is there any way I can make the info thats input in one column (selected
by
> dropdown list) determine which (one of several) dropdown list is used in
> another column?

If these are data validation dropdown lists, there are instructions here
for dependent lists:

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

gettin-older wrote:
> Is there any way I can make the info thats input in one column (selected by
> dropdown list) determine which (one of several) dropdown list is used in
> another column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank to very much!

"Debra Dalgleish" wrote:

> If these are data validation dropdown lists, there are instructions here
> for dependent lists:
>
> http://www.contextures.com/xlDataVal02.html
>
> gettin-older wrote:
> > Is there any way I can make the info thats input in one column (selected by
> > dropdown list) determine which (one of several) dropdown list is used in
> > another column?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome!

gettin-older wrote:
> Thank to very much!
>
> "Debra Dalgleish" wrote:
>
>
>>If these are data validation dropdown lists, there are instructions here
>>for dependent lists:
>>
>> http://www.contextures.com/xlDataVal02.html
>>
>>gettin-older wrote:
>>
>>>Is there any way I can make the info thats input in one column (selected by
>>>dropdown list) determine which (one of several) dropdown list is used in
>>>another column?
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html