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?

Make input in one column determine dropdown list in another.
 

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?

Make input in one column determine dropdown list in another.
 

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

Make input in one column determine dropdown list in another.
 

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

Make input in one column determine dropdown list in another.
 

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