Compare two column values using VLOOKUP function

[Srikanth0990]

COL1	COL2	Result (Matching/Not matching)
0029	0029	0029  (Yes)
0057	0218	No
0218	1132	0218  (Yes)
0367	1310	No
0726	2450	No
0729	2791	No
0826	3220	No
0913	3290	No
1095	3360	No
1096	3430	No
1097	3640	N
1132	4500	1132  (Yes)
1309	4542	No
1310	4830	1310  (Yes)
1449	8551	No
1686	8571	No
1688	8575	No
1689	8577	No
1724	8582	No
1753	8590	No
1798	8902	No
2055	8904	No
2450	8912	2450   (Yes)
2670	8927	No
2791	8929	2791  (Yes)
2800	8931	No
3220	8933	3220   (Yes)
3290	8939	3290   (Yes)
3360	8953	3360   (Yes)
3430	8955	3430   (Yes)
3640	8962	3640   (Yes)
4500	8974	4500   (Yes)
4542	8981	4542   (Yes)
4830	9536	4830   (Yes)
7082	9538	No
7289
7291
7311
7354
7458
8550
8551		8551
8555
8558
8560
8561
8571		8571
8575		8575
8577		8577
8580
8582		8582
8590		8590
8595
8699
8706
8713
8902		8902
8904		8904
8909
8912		8912
8927		8927
8929		8929
8931		8931
8933		8933
8939		8939
8946
8949
8953		8953
8955		8955
8962		8962
8974		8974
8975
8981		8981
9198
9199
9340
9516
9536		9536
9538		9538

[#2]

@Srikanth0990 

Assuming that COL1 is column A and COL2 is column B, enter the following formula in row 2 of the result column:

=IF(ISNUMBER(MATCH(A2, B:B, 0)), A2&" (Yes)", "No")

Fill down

[#3]

It's not working

[#4]

@Srikanth0990 

Demo workbook that shows the working formula attached.

[#5]

Thanks a ton!