Forum Discussion
autofill and drop down list
I have a list of names with that is 50 rows long, and growing, with 3 additional columns with corresponding information. I want to type a name in cell B1 and have a drop down list that corresponds to...
You may add at any place of the workbook dependant ranges for the drop-down lists as
with formulas
=UNIQUE(Table2[ctg])
=FILTER(Table2[mfr],Table2[ctg]=$B$1,"---")
=FILTER(Table2[mod],(Table2[ctg]=$B$1)*(Table2[mfr]=$C$5),"---")
=FILTER(Table2[ser],(Table2[ctg]=$B$1)*(Table2[mfr]=$C$5)*(Table2[mod]=$E$5),"---")and use references on them in data validation, e.g.