Lookup Help without Duplication

[Blake86]

I am attempting to have this autofill when I use a drop down. I tried to simplify this as much as possible. I am trying to make it so when I use the drop down for type ("A","B","C") it fills in the corresponding "Item name" into the "item A" list same with "Item B" and "Item C". I can get it to pull the data I want with XLOOKUP, but I cannot figure out how to get it to not duplicate or always take the first match to "A/B/C" for the lookup_value after the first match.

-Not all items will have types
-The "Type" column is a drop down from "Column1"

 

[Sergius]

Is this right for you?

Book1.xlsm
	D	E	F	G	H	I
20	Type	Item name		ItemA	ItemB	ItemC
21	A	Z		Z	Y	V
22	B	Y		X
23	A	X
24		W
25	C	V
Sheet2

Cell Formulas
Range	Formula
G21:G22	G21	=FILTER(E21:E25,D21:D25="A")
H21	H21	=FILTER(E21:E25,D21:D25="B")
I21	I21	=FILTER(E21:E25,D21:D25="C")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
D21:D25	List	A;B;C

 

[Blake86]

Is this right for you?

Book1.xlsm
	D	E	F	G	H	I
20	Type	Item name		ItemA	ItemB	ItemC
21	A	Z		Z	Y	V
22	B	Y		X
23	A	X
24		W
25	C	V
Sheet2

Cell Formulas
Range	Formula
G21:G22	G21	=FILTER(E21:E25,D21:D25="A")
H21	H21	=FILTER(E21:E25,D21:D25="B")
I21	I21	=FILTER(E21:E25,D21:D25="C")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
D21:D25	List	A;B;C

This will work! THANK YOU!!