Make input in one column determine dropdown list in another.

[Guest]

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?

 

[Bob Phillips]

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)

 

[Debra Dalgleish]

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

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

 

[Guest]

Thank to very much!

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

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

 

[Debra Dalgleish]

You're welcome!

Thank to very much!

: