3 way dependant lists
If i have 2 drop down lists, where by selecting the first it narrows down the
options in the second list to those that are applicable to the chosen choice.
is it possible and if so how do i then link this second selected option to a
third drop down box?
for example, by choosing a login in the first box it then shortlists
relevant domains and finally i want to link the appropriate user names that
are relevant to the choice in the second box (iv used named ranges). the
first 2 formulas i used for the first 2 boxes that works well, in
data/validation respectively we
=IF(D5="",DealerIDList,INDEX(DealerIDColumn,MATCH( D5,LoginColumn,0)))
=OFFSET(DealerIDStart,MATCH(B5,DealerIDColumn,0)-1,1,COUNTIF(DealerIDColumn,B5),1)
Much appreciated
Paul
|