autofill and drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2485290%22%20slang%3D%22en-US%22%3Eautofill%20and%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2485290%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20names%20with%20that%20is%2050%20rows%20long%2C%20and%20growing%2C%20with%203%20additional%20columns%20with%20corresponding%20information.%20I%20want%20to%20type%20a%20name%20in%20cell%20B1%20and%20have%20a%20drop%20down%20list%20that%20corresponds%20to%20the%20name%20that%20has%20been%20entered%20appear%20in%20cell%20C5.%20When%20a%20selection%20is%20made%20from%20that%20drop%20down%20cell%20E5%20will%20be%20filled%20in%20from%20column%20J%20and%20cell%20G5%20will%20be%20filled%20in%20from%20Column%20L.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2485290%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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