Forum Discussion
Compare two column values using VLOOKUP function
| 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 |
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
- It's not working
Demo workbook that shows the working formula attached.
