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


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


with formulas


and use references on them in data validation, e.g.