autofill and drop down list

Occasional Visitor

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 the name that has been entered appear in cell C5. When a selection is made from that drop down cell E5 will be filled in from column J and cell G5 will be filled in from Column L.

1 Reply

@Daryl338 

You may add at any place of the workbook dependant ranges for the drop-down lists as

image.png

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.

image.png