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,rng 1,rng2))),1)

where E1 is the first DD.

--

HTH

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


"gettin-older" wrote in message
...
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