Finding a match - two columns of data

[divster27]

I've got two columns of data, both numeric.
Column A has all the values, Column C some
I want to see a value in column B to say if there is a match for the data in Col A somewhere in Col C
Couple of examples here - there's about 250k rows in the main sheet i have

eBayListings.xlsx
	A	B	C
1	167425094627	Yes	167425094627
2	146476451303	Yes	146476451303
3	167425148672	Yes	167425148672
4	146493087374	Yes	146493087374
5	167425113413	Yes	167425113413
6	167425113404	Yes	167425113404
7	146476391003	Yes	146476391003
8	167405549953	Yes	167405549953
9	146476345470	Yes	146476345470
10	146493084861	Yes	146493084861
11	167405614223	Yes	167405614223
12	146476394344	Yes	146476394344
13	146476394338	Yes	146476394338
14	167405614253	Yes	167405614253
15	146476394365	Yes	146476394365
16	167413183129	Yes	167413183129
17	146476394397	Yes	146476394397
18	167405582472	Yes	167405582472
19	146476445706	Yes	146476445706
20	167405561986	Yes	167405561986
21	146476408227	Yes	146476408227
22	167405671805	Yes	167405671805
23	146482429146	Yes	146482429146
24	167425083205	Yes	167425083205
25	146493090400	Yes	146493090400
26	167405543461	Yes	167405543461
27	146486808195	Yes	146486808195
28	146476356031	Yes	146476356031
29	167405678215	Yes	167405678215
30	167405555223	Yes	167405555223
31	167405503937	Yes	167405503937
32	167405674419	Yes	167405674419
33	146476351774	Yes	146476351774
34	146476372698	Yes	146476372698
35	167425064433	Yes	167425064433
36	146476340289	Yes	146476340289
37	146476345887	Yes	146476345887
38	167405634608	Yes	167405634608
39	146476412389	Yes	146476412389
40	146493099508	Yes	146493099508
41	167405553833	Yes	167405553833
42	167405556072	Yes	167405556072
43	167413180176	Yes	167413180176
44	146476389752	Yes	146476389752
45	167425067510	Yes	167425067510
46	167405548282	Yes	167405548282
47	146476346788	Yes	146476346788
48	167425082758	No	167405551964
find removed

 

[Peter_SSs]

Like this?

25 04 06.xlsm
	A	B	C
1	167425094627	Yes	167425094627
2	146476451303	Yes	146476451303
3	167425148672	Yes	167425148672
4	146493087374	Yes	146493087374
5	167425113413	Yes	167425113413
6	167425113404	Yes	167425113404
7	146476391003	Yes	146476391003
8	167405549953	Yes	167405549953
9	146476345470	Yes	146476345470
10	146493084861	Yes	146493084861
11	167405614223	Yes	167405614223
12	146476394344	Yes	146476394344
13	146476394338	Yes	146476394338
14	167405614253	Yes	167405614253
15	146476394365	Yes	146476394365
16	167413183129	Yes	167413183129
17	146476394397	Yes	146476394397
18	167405582472	Yes	167405582472
19	146476445706	Yes	146476445706
20	167405561986	Yes	167405561986
21	146476408227	Yes	146476408227
22	167405671805	Yes	167405671805
23	146482429146	Yes	146482429146
24	167425083205	Yes	167425083205
25	146493090400	Yes	146493090400
26	167405543461	Yes	167405543461
27	146486808195	Yes	146486808195
28	146476356031	Yes	146476356031
29	167405678215	Yes	167405678215
30	167405555223	Yes	167405555223
31	167405503937	Yes	167405503937
32	167405674419	Yes	167405674419
33	146476351774	Yes	146476351774
34	146476372698	Yes	146476372698
35	167425064433	Yes	167425064433
36	146476340289	Yes	146476340289
37	146476345887	Yes	146476345887
38	167405634608	Yes	167405634608
39	146476412389	Yes	146476412389
40	146493099508	Yes	146493099508
41	167405553833	Yes	167405553833
42	167405556072	Yes	167405556072
43	167413180176	Yes	167413180176
44	146476389752	Yes	146476389752
45	167425067510	Yes	167425067510
46	167405548282	Yes	167405548282
47	146476346788	Yes	146476346788
48	167425082758	No	167405551964
Match

Cell Formulas
Range	Formula
B1:B48	B1	=IF(ISNUMBER(MATCH(A1,C:C,0)),"Yes","No")

 

[divster27]

perfect - thank you very much

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.