How do i show a large selection of data depending on a drop down list.

[Luke1690]

Morning,

I'm creating an order sheet the top of the order form stays the same.

i have created a multi dependant drop down list (B16 is the final drop down list)

when a value is selected from B16 i want it to show a large part list corresponding to that value.
the cells i want it to show in are ( A18:G18) down

i have the list of parts on separate sheet in the same range of cells (A18:G18) The list ends at (A32:G32)

Please can someone help me i believe i need to use VLOOKUP But i don't mind using code if that's easier.

Thanks Guys

 

[awoohaw]

Im not sure exactly what you want. but is this something that would work? (I'm not sure why the wrap in the formula text occured)

WorkBook1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
10
11	DropDownList	J18:J32
12	Parts:	K18:P32
13
14	A18:	=LET(a,Parts,b,$B$16,r,XMATCH(B16,DropDownLIst,0),c,COLUMNS(Parts), INDEX(Parts,r,N(SEQUENCE(1,c,1,1))))
15
16	Part:	VJP
17										List	Parts
18	JPA	ICD	SDG	UCN	EBN	NQF				GDN	WEI	ALQ	MAX	ACK	EVX	STP
19										EEO	STB	FOL	KQW	BMC	GLF	TLA
20										VMO	DOL	VXI	QVD	SSR	GSM	FZH
21										ZMT	MAS	WUT	BFO	EDS	EGY	OKU
22										PSW	IDU	PNN	XCM	QGI	NKR	UAO
23										RNL	BVN	HQF	AGQ	CJQ	SZL	YVE
24										WFK	PWM	XIP	HOA	TPB	NVJ	QOU
25										NPW	OPD	CQL	APH	NMI	UAP	SBE
26										VJP	JPA	ICD	SDG	UCN	EBN	NQF
27										CAZ	LXP	MOM	YUA	CSG	CWU	BCY
28										YCF	IYA	PAB	ZXC	UXI	QGR	OQG
29										HKI	RMS	CFD	IUD	PNC	GQH	LSS
30										LJM	PPJ	VIT	QMW	VHE	KWZ	IHP
31										URM	OII	GTC	UKJ	HVF	QFX	ZRM
32										ZQC	QRG	ZLO	LYK	SBN	BQP	WJU
Sheet1

Cell Formulas
Range	Formula
B14	B14	=FORMULATEXT(A18)
A18:F18	A18	=LET(a,Parts,b,$B$16,r,XMATCH(B16,DropDownLIst,0),c,COLUMNS(Parts), INDEX(Parts,r,N(SEQUENCE(1,c,1,1))))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
DropDownLIst	=Sheet1!$J$18:$J$32	A18
Parts	=Sheet1!$K$18:$P$32	A18

Cells with Data Validation
Cell	Allow	Criteria
B16	List	=DropDownLIst

 

[Fluff]

@awoohaw The OP's profile they are using 2016 & so do not have most of those functions.