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]

That error says that nothing matched both criteria.
Check that all the dates are real dates & not text, also check to ensure that the values in col E on both sheets do not contain any leading/trailing spaces.

 

[NORRILLOUS]

That error says that nothing matched both criteria.
Check that all the dates are real dates & not text, also check to ensure that the values in col E on both sheets do not contain any leading/trailing spaces

I checked the dates and I looked at the spaces thing. there was a leading space on there so I added the space and it fixed all the 6P items but not the 2P items ?

Here is another snap shot

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		176089,176085,176084,176090
10	GT	Skiv	Base	473 ml	6P		176089,176085,176084,176090
11	GT	Skiv	Base	315 ml	6P		176089,176085,176084,176090
DAILY ORDERS

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

 

[Fluff]

You would be better of removing the spaces, otherwise they may cause you problems again in the future.
Can you post the relevant data that the formula is looking at.

 

[NORRILLOUS]

You would be better of removing the spaces, otherwise they may cause you problems again in the future.
Can you post the relevant data that the formula is looking at.

Production Schedule Analysis.xlsm
	A	B	C	D	E	F	G	H	I	J
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
22
23	5/3/2021	237 ml	Base	GT	6P	0175992-S	934905881	48,000	-	/m
24	5/10/2021	237 ml	Base	GT	6P	0176339-S	935000455	48,000	-	/m
25	5/17/2021	237 ml	Base	GT	6P	176511	935048346	48,000	-	/m
26	5/17/2021	237 ml	Base	GT	6P	176512	935048345	48,000	-	/m
27
28
29	5/11/2021	1000 ml	Base	TR	2P	0176374-S	935002821	346,000	Skiv	/pbs
30	5/11/2021	1000 ml	Base	TR	2P	0176315-S	934991341	480,000	Skiv	/pbs
31	5/18/2021	1000 ml	Base	TR	2P	0175554-S	934793749	140,000	Skiv	/pbs
32	6/1/2021	1000 ml	Base	TR	2P	0176048-S	934924866	80,000	Skiv	/pbs
33	6/1/2021	1000 ml	Base	TR	2P	0176047-S	934924869	40,000	Skiv	/pbs
Press Schedule

 

[Fluff]

None of those dates match today.

 

[NORRILLOUS]

None of those dates match today.

I'M AN IDIOT!!! Thanks for your help! I Went ahead and scrubbed the spaces from the data set and otherwise.

 

[Fluff]

You're welcome & thanks for the feedback.