Formula to find a ticket number in a list of winning tickets

[Nlhicks]

What formula can I use to mark the middle column with a True or False if the ticket number is found in the winning tickets? I tried using =IF(VLOOKUP(AF2641, 'Ticket Number'!$A:$A,1,FALSE),TRUE,FALSE) but ran into problems when other numbers were checked.

Ticket Number		Winning Tickets
111111​		652558
222222​		652558
655610​		652559
659420​		658009
655620​		659420,659421
652504​		659120,659421,659420
655620​		658174,658174
653300​		652638
659376​		659160
659484​		659424,652806
		659422,659423
		659376,659377,659378,652484,659376
		655765,655510
		640349,640350
		640246,653300,659817,653302,659819
		659181,659184
		659180,659186
		655521,658176
		655521,652520
		652501
		652474,652504
		652474,652505
		655617,655618,655619,655620,655621,655622,655623
		652504,652538
		652504,652531
		655610
		655617,655618,655619,655620,655621,655622,655623
		652464

 

[DanteAmor]

Try

Libro2
	A	B	C
1	Ticket Number		Winning Tickets
2	111111	FALSO	652558
3	222222	FALSO	652558
4	655610	FALSO	652559
5	659420	VERDADERO	658009
6	655620	FALSO	659420,659421
7	652504	FALSO	659120,659421,659420
8	655620	FALSO	658174,658174
9	653300	FALSO	652638
10	659376	VERDADERO	659160
11	659484	FALSO	659424,652806
12			659376,659377,659378,652484,659376
Hoja1

Cell Formulas
Range	Formula
B2:B11	B2	=IFERROR(IF(MATCH("*"&A2&"*",C:C,0),TRUE),FALSE)

 

[ExceLoki]

here's another option

Book1
	A	B	C
1	Ticket Number		Winning Tickets
2	111111	FALSE	652558
3	222222	FALSE	652558
4	655610	TRUE	652559
5	659420	TRUE	658009
6	655620	TRUE	659420,659421
7	652504	FALSE	659120,659421,659420
8	655620	TRUE	658174,658174
9	653300	TRUE	652638
10	659376	TRUE	659160
11	659484	TRUE	659424,652806
12			659422,659423
13			659376,659377,659378,652484,659376
14			655765,655510
15			640349,640350
16			640246,653300,659817,653302,659819
17			659181,659184
18			659180,659186
19			655521,658176
20			655521,652520
21			652501
22			652474,652504
23			652474,652505
24			655617,655618,655619,655620,655621,655622,655623
25			652504,652538
26			652504,652531
27			655610
28			655617,655618,655619,655620,655621,655622,655623
29			652464
Sheet1

Cell Formulas
Range	Formula
B2	B2	=IFERROR(IF(MATCH(A2,UNIQUE(TEXTSPLIT(TEXTJOIN(",",TRUE,$C$2:$C$29),",")))>0,TRUE),FALSE)
B3:B11	B3	=IFERROR(IF(MATCH(A3,UNIQUE(TEXTSPLIT(TEXTJOIN(",",TRUE,$C$2:$C$29),",")))>0,TRUE,FALSE),FALSE)

 

[Nlhicks]

How would this change if I need to check all of the ticket numbers against each row of the winning tickets? In other words, I need to look at each row of winning tickets and parse through each ticket number to see if that ticket number is in that row of the winning tickets then do the same thing to each row?Put a True if that row contains at least one ticket number or False otherwise.

 

[Nlhicks]

How would this change if I need to check all of the ticket numbers against each row of the winning tickets? In other words, I need to look at each row of winning tickets and parse through each ticket number to see if that ticket number is in that row of the winning tickets then do the same thing to each row?Put a True if that row contains at least one ticket number or False otherwise.

I keep ending up with #SPILL using this formula =IFERROR(IF(MATCH("*"&A2:A52&"*",'UMZ Contingencies'!AF2,0),TRUE,),FALSE)

 

[Dave Patton]

T202310a.xlsm
	A	B	C	D	E
1	Ticket Number		Row	Winning Tickets
2	111111			652558
3	222222			652558
4	655610			652559
5	659420	TRUE	6	658009
6	655620			659420,659421	TRUE
7	652504			659120,659421,659000
8	655620			658174,658174
9	653300			652638
10	659376	TRUE	12	659160
11	659484			659424,652806
12				659376,652806	TRUE
13
2i

Cell Formulas
Range	Formula
B2:B11	B2	=IFERROR(MATCH("*"&A2&"*",D:D,0)>0,"")
C2:C11	C2	=IF(B2=TRUE,MATCH("*"&A2&"*",D:D,0),"")
E2:E12	E2	=IF(ISNUMBER(MATCH(ROW(),$C$2:$C$11,0)),TRUE,"")

 

[DanteAmor]

keep ending up with #SPILL using this formula =IFERROR(IF(MATCH("*"&A2:A52&"*",'UMZ Contingencies'!AF2,0),TRUE,),FALSE)

I'm confused.
Where is the Ticket Number data?
Where is the Winning Tickets data?

You must specify which sheet and which column the data is in.

Please, use xl2bb tool to put a sample of your 2 sheets.