lookup value and return every instance of that value

[philip121]

I need to lookup each value from column A in column B, and return instances of that value from column B into column C.
Example:
lookup from column A: SXWTK00022

results found in column B:

SXWTK00022-2XL

SXWTK00022-LG

SXWTK00022-MD

SXWTK00022-SM

SXWTK00022-XL

copy each result and paste in column C.

Your help is greatly appreciated.

 

[Peter_SSs]

Does this one do what you want?

20 09 05.xlsm
	A	B	C
1	Sale items	SKU	Result
2	SXWTK00022	custom10	SXWTK00022-2XL
3	SXWTK00028	custom60	SXWTK00022-LG
4	SXTWK00030	custom70	SXWTK00022-MD
5	SXWLS00005	SXWTK00022-2XL	SXWTK00022-SM
6		SXWTK00022-LG	SXWTK00022-XL
7		SXWTK00022-MD	SXWTK00028-LG
8		SXWTK00022-SM	SXWTK00028-XL
9		SXWTK00022-XL	SXWLS00005-2XL
10		SXWTK00028-LG	SXWLS00005-LG
11		SXWTK00028-XL	SXWLS00005-MD
12		SXWLS00005-2XL
13		SXWLS00005-LG
14		SXWLS00005-MD
15		SXWTK99928-XL
16
Lookup SKUs (2)

Cell Formulas
Range	Formula
C2:C11	C2	=FILTER(B2:B20,ISNUMBER(MATCH(LEFT(B2:B20,FIND("-",B2:B20&"-")-1),A2:A5,0)))
Dynamic array formulas.

 

[philip121]

Does this one do what you want?

20 09 05.xlsm
	A	B	C
1	Sale items	SKU	Result
2	SXWTK00022	custom10	SXWTK00022-2XL
3	SXWTK00028	custom60	SXWTK00022-LG
4	SXTWK00030	custom70	SXWTK00022-MD
5	SXWLS00005	SXWTK00022-2XL	SXWTK00022-SM
6		SXWTK00022-LG	SXWTK00022-XL
7		SXWTK00022-MD	SXWTK00028-LG
8		SXWTK00022-SM	SXWTK00028-XL
9		SXWTK00022-XL	SXWLS00005-2XL
10		SXWTK00028-LG	SXWLS00005-LG
11		SXWTK00028-XL	SXWLS00005-MD
12		SXWLS00005-2XL
13		SXWLS00005-LG
14		SXWLS00005-MD
15		SXWTK99928-XL
16
Lookup SKUs (2)

Cell Formulas
Range	Formula
C2:C11	C2	=FILTER(B2:B20,ISNUMBER(MATCH(LEFT(B2:B20,FIND("-",B2:B20&"-")-1),A2:A5,0)))
Dynamic array formulas.

Yes! That's perfect.
Thank You

 

[Peter_SSs]

Yes! That's perfect.
Thank You

You're welcome. Thanks for the follow-up. Sorry I din't interpret correctly the first time.