Create List in row if value matches

[NORRILLOUS]

Sheet 1

A​	B​	C​
Machine​	Order Number​	ID Number​
3	1hbkb1	252we
2	qfw1	262er
1	wf3df	2er7e
1	wgfwsg	2e7e7
2	wdgw	27e2e748
3	cedvh	4848859

Sheet 2

A​	B​
Machine​	O,ID Number​
1	wf3df,2er7e,wgfwsg,2e7e7

For my example, I would like to use the data above in sheet 1 to return values (Columns B,C) to sheet 2 (Column B) if value is found in Column A

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[NORRILLOUS]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I am using Office 365. and I updated my profile! Thanks for the tip

 

[Fluff]

Ok, thanks for that. How about

=TEXTJOIN(",",,FILTER(Sheet1!$B$2:$C$7,Sheet1!$A$2:$A$7=A2))

 

[NORRILLOUS]

That works really well is there a way to add a second filter to filter it further down if needed? ie..

=TEXTJOIN(",",,FILTER(Order Number Range,Machine Range=A2),Filter(Date Range=D2)

 

[Fluff]

Yes it's possible, but you would need to supply some sample data

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[NORRILLOUS]

Yes it's possible, but you would need to supply some sample data

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

I tried this as well. but I get a #VALUE! error. Let me get the other setup and I will return.

=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,'Press Schedule'!$E$2:$E$5000=E18)*('Press Schedule'!A2:A5000=G3))

 

[NORRILLOUS]

Data:

Production Schedule Analysis.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Order Due Date	Package.Volume	Package.Shape	Package.System	Machine Name	Order Number	Global Order ID	Order Quantity	Package.Sealing Var.	Packaging Material.Denomination	Customer Name	Design Number/ Revision	Production Status
2	4/30/2021	946 ml	Base	GT	6P	176089	934935677	24,000	-	/m	Clover	US-L952-04	Not Started
3	4/30/2021	946 ml	Base	GT	6P	176085	934935681	48,000	-	/m	Clover	US-L923-04	Not Started
4	4/30/2021	946 ml	Base	GT	6P	176084	934935680	24,000	-	/m	Clover	US-L953-03	Not Started
5	4/30/2021	946 ml	Base	GT	6P	176090	934935684	24,000	-	/m	Clover	US-L926-02	Not Started
6	5/3/2021	946 ml	Base	GT	6P	176149	934955075	24,000	-	/m	Gold Medal Products Co	US-R209-02	Not Started
Press Schedule

Sheet I am working in:

Production Schedule Analysis.xlsm
	A	B	C	D	E	F	G	H	I	J
1							Week 18
2	TR/GT	Skive		Size	Machine		Friday
3							4/30/2021
18	GT	-	Mini	237 ml	1P		#VALUE!		#CALC!
19	GT	-	Mini	315 ml	3P		176033,176043,176042,175958,175959,0176158-S,0176184-S,0176177-S,176187,176186,176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101,176223		#N/A
20	GT	-	Mini	237 ml	3P		176033,176043,176042,175958,175959,0176158-S,0176184-S,0176177-S,176187,176186,176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101,176223		#N/A
21	GT	-	Mini	180 ml	3P		176033,176043,176042,175958,175959,0176158-S,0176184-S,0176177-S,176187,176186,176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101,176223		#N/A
22	GT	-	Mini	118 ml	3P		176033,176043,176042,175958,175959,0176158-S,0176184-S,0176177-S,176187,176186,176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101,176223		#N/A
23	GT	-	Mini	237 ml	4P		###################################################################################################################################################################		#N/A
24	GT	-	Mini	180 ml	4P		###################################################################################################################################################################		#N/A
25	GT	-	Mini	118 ml	4P		###################################################################################################################################################################		#N/A
26	GT	-	Mini	315 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722,175995,176303,0176284-S,0176282-S,0176283-S,176241,176285,176301,175994,0176028-S,176233,176232,176027,176238,176367,176119		#N/A
27	GT	-	Mini	237 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722,175995,176303,0176284-S,0176282-S,0176283-S,176241,176285,176301,175994,0176028-S,176233,176232,176027,176238,176367,176119		#N/A
28	GT	-	Mini	180 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722,175995,176303,0176284-S,0176282-S,0176283-S,176241,176285,176301,175994,0176028-S,176233,176232,176027,176238,176367,176119		#N/A
29	GT	-	Mini	118 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722,175995,176303,0176284-S,0176282-S,0176283-S,176241,176285,176301,175994,0176028-S,176233,176232,176027,176238,176367,176119		#N/A
DAILY ORDERS

Cell Formulas
Range	Formula
G1	G1	="Week "&WEEKNUM(G3)
G2	G2	=G3
G3	G3	=TODAY()
G18	G18	=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,'Press Schedule'!$E$2:$E$5000=E18)*('Press Schedule'!A2:A5000=G3))
G19:G23,G25:G29	G19	=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,'Press Schedule'!$E$2:$E$5000=E19))
G24	G24	=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,'Press Schedule'!$E$2:$E$5000=E24,""))
I18	I18	=TEXTJOIN(",",,FILTER('Press Schedule'!F2:F5000,'Press Schedule'!E2:E5000='Change Over Triggers'!E5))
I19:I29	I19	=SMALL(IF('Press Schedule'!E6:E5001=E19,ROW('Press Schedule'!F3:F5001)),ROW(2:2))
Press CTRL+SHIFT+ENTER to enter array formulas.

I would ultimately like to filter this down by Machine, Date & Size.

 

[Fluff]

That formula should be

=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,('Press Schedule'!$E$2:$E$5000=E18)*('Press Schedule'!A2:A5000=G3)))

 

[NORRILLOUS]

That worked very well! On most of it... I am not sure what I did wrong in the other cells that are getting the #CALC! Error

Production Schedule Analysis.xlsm
	A	B	C	D	E	F	G
2	TR/GT	Skive		Size	Machine		Friday
3							4/30/2021
4	TR	Skiv	Base	1000 ml	2P		#CALC!
5	TR	Skiv	Base	946 ml	2P		#CALC!
6	TR	Skiv	Base	473 ml	2P		#CALC!
7	TR	Skiv	Base	315 ml	2P		#CALC!
8	TR	Skiv	Base	237 ml	2P		#CALC!
9	GT	Skiv	Base	946 ml	6P		#CALC!
10	GT	Skiv	Base	473 ml	6P		#CALC!
11	GT	Skiv	Base	315 ml	6P		#CALC!
12	GT	Skiv	Base	237 ml	6P		#CALC!
13	GT	-	Base	946 ml	6P		#CALC!
14	GT	-	Base	473 ml	6P		#CALC!
15	GT	-	Base	315 ml	6P		#CALC!
16	GT	-	Base	237 ml	6P		#CALC!
17
18	GT	-	Mini	237 ml	1P		176105,176221,0176206-S,0175966-S,0176213-S,0176203-S
19	GT	-	Mini	315 ml	3P		176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101
20	GT	-	Mini	237 ml	3P		176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101
21	GT	-	Mini	180 ml	3P		176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101
22	GT	-	Mini	118 ml	3P		176205,176222,0175970-S,0176215-S,0176154-S,0176153-S,0176152-S,176101
23	GT	-	Mini	237 ml	4P		0176201-S,0175715-S,0176161-S,0176313-S,0176314-S,0176311-S,0176312-S,0176198-S,0176197-S,0175968-S,0176196-S,0176199-S,0176200-S
24	GT	-	Mini	180 ml	4P		0176201-S,0175715-S,0176161-S,0176313-S,0176314-S,0176311-S,0176312-S,0176198-S,0176197-S,0175968-S,0176196-S,0176199-S,0176200-S
25	GT	-	Mini	118 ml	4P		0176201-S,0175715-S,0176161-S,0176313-S,0176314-S,0176311-S,0176312-S,0176198-S,0176197-S,0175968-S,0176196-S,0176199-S,0176200-S
26	GT	-	Mini	315 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722
27	GT	-	Mini	237 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722
28	GT	-	Mini	180 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722
29	GT	-	Mini	118 ml	5P		176211,176104,176103,176102,176216,176204,0176150-S,176151,175969,176214,175723,176095,175722
DAILY ORDERS

Cell Formulas
Range	Formula
G2	G2	=G3
G3	G3	=TODAY()
G4:G16,G18:G29	G4	=TEXTJOIN(",",,FILTER('Press Schedule'!$F$2:$F$5000,('Press Schedule'!$E$2:$E$5000=E4)*('Press Schedule'!$A$2:$A$5000=$G$3)))