Make input in one column determine dropdown list in another.

G

gettin-older

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?
 
B

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)
 
Top